home *** CD-ROM | disk | FTP | other *** search
| AllFusion ERwin data | 1997-06-01 | 138.2 KB |
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was processed as: AllFusion ERwin data
(other/allFusionERwinData).
This format is not currently supported by dexvert.
| Confidence | Program | Detection | Match Type | Support
|
|---|
| 1%
| dexvert
| AllFusion ERwin data (other/allFusionERwinData)
| magic
| Unsupported |
| 100%
| file
| data
| default
| |
| 100%
| TrID
| AllFusion ERwin data
| default
| |
| 100%
| gt2
| Kopftext: 'V2.35 ERwi'
| default (weak)
|
|
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 56 32 2e 33 35 20 45 52 | 77 69 00 00 00 00 ac c2 |V2.35 ER|wi......|
|00000010| 00 00 b6 c2 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 05 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 13 00 00 00 00 00 |........|........|
|00000050| 01 00 00 00 00 00 00 00 | ac 00 00 00 5b 1b 00 00 |........|....[...|
|00000060| 00 00 00 00 19 00 00 00 | 09 00 00 00 00 00 00 00 |........|........|
|00000070| 00 00 00 00 06 00 00 00 | 03 00 00 00 00 00 00 00 |........|........|
|00000080| 00 00 00 00 02 00 60 00 | 32 00 00 00 28 c3 00 00 |......`.|2...(...|
|00000090| 14 00 00 00 d5 c2 00 00 | 09 00 08 00 63 68 61 72 |........|....char|
|000000a0| 28 31 38 29 00 00 00 00 | 00 00 00 00 00 00 13 00 |(18)....|........|
|000000b0| 58 25 4b 65 79 54 79 70 | 65 25 54 61 62 6c 65 4e |X%KeyTyp|e%TableN|
|000000c0| 61 6d 65 00 00 00 00 00 | 00 00 00 00 00 02 00 00 |ame.....|........|
|000000d0| 00 00 00 07 00 4e 6f 74 | 65 20 49 44 ff ff 00 00 |.....Not|e ID....|
|000000e0| 00 01 00 09 00 4e 6f 74 | 65 20 54 65 78 74 ff ff |.....Not|e Text..|
|000000f0| 00 00 00 00 00 00 00 0c | 00 00 00 01 00 00 00 19 |........|........|
|00000100| 00 00 00 00 01 00 00 00 | 1a 00 00 00 00 01 00 00 |........|........|
|00000110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000120| 00 00 00 14 00 00 00 00 | 02 00 00 00 1a 00 00 00 |........|........|
|00000130| 00 02 00 00 00 00 00 00 | 00 00 04 00 00 00 00 00 |........|........|
|00000140| 00 00 00 01 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00000150| 00 00 00 00 00 01 00 00 | 00 00 00 00 00 00 02 00 |........|........|
|00000160| 00 00 00 00 00 00 00 02 | 00 00 00 0c 00 00 00 0b |........|........|
|00000170| 00 4d 6f 76 69 65 5f 67 | 65 6e 72 65 00 00 05 00 |.Movie_g|enre....|
|00000180| 00 00 01 00 00 00 0f 00 | 00 00 00 01 00 00 00 64 |........|.......d|
|00000190| 00 00 00 00 01 00 00 00 | 0f 00 00 00 00 04 00 00 |........|........|
|000001a0| 00 00 00 00 00 00 02 00 | 00 00 00 00 00 00 00 07 |........|........|
|000001b0| 00 00 00 05 00 00 00 04 | 00 27 43 48 27 00 00 00 |........|.'CH'...|
|000001c0| 00 00 00 00 00 09 00 00 | 00 01 00 00 00 0f 00 00 |........|........|
|000001d0| 00 00 00 00 00 00 00 00 | 00 00 00 02 00 00 00 1e |........|........|
|000001e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000200| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000210| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 05 00 |........|........|
|00000220| 00 00 04 00 27 43 44 27 | 00 00 00 00 00 00 00 00 |....'CD'|........|
|00000230| 09 00 00 00 01 00 00 00 | 0f 00 00 00 00 00 00 00 |........|........|
|00000240| 00 00 00 00 00 00 02 00 | 00 00 1e 00 00 00 00 00 |........|........|
|00000250| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000260| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000270| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000280| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 04 00 27 |........|.......'|
|00000290| 45 44 27 00 00 00 00 00 | 00 00 00 09 00 00 00 01 |ED'.....|........|
|000002a0| 00 00 00 0f 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002b0| 00 02 00 00 00 1e 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002f0| 00 00 00 00 05 00 00 00 | 04 00 27 48 52 27 00 00 |........|..'HR'..|
|00000300| 00 00 00 00 00 00 09 00 | 00 00 01 00 00 00 0f 00 |........|........|
|00000310| 00 00 00 00 00 00 00 00 | 00 00 00 00 02 00 00 00 |........|........|
|00000320| 1e 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 05 |........|........|
|00000360| 00 00 00 04 00 27 4e 52 | 27 00 00 00 00 00 00 00 |.....'NR|'.......|
|00000370| 00 09 00 00 00 01 00 00 | 00 0f 00 00 00 00 00 00 |........|........|
|00000380| 00 00 00 00 00 00 00 02 | 00 00 00 1e 00 00 00 00 |........|........|
|00000390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003c0| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 04 00 |........|........|
|000003d0| 27 53 46 27 00 00 00 00 | 00 00 00 00 09 00 00 00 |'SF'....|........|
|000003e0| 01 00 00 00 0f 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003f0| 00 00 02 00 00 00 1e 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000400| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000410| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000420| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000430| 00 00 00 00 00 05 00 00 | 00 04 00 27 53 4d 27 00 |........|...'SM'.|
|00000440| 00 00 00 00 00 00 00 09 | 00 00 00 01 00 00 00 0f |........|........|
|00000450| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 02 00 00 |........|........|
|00000460| 00 1e 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000470| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000480| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000490| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004a0| 00 00 00 00 81 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004b0| 00 00 00 00 09 00 00 00 | 01 00 00 00 0f 00 00 00 |........|........|
|000004c0| 00 00 00 00 00 00 00 00 | 00 00 02 00 00 00 1e 00 |........|........|
|000004d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000004f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000500| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000510| 00 08 00 00 00 01 00 00 | 00 1e 00 00 00 00 01 00 |........|........|
|00000520| 00 00 32 00 00 00 00 01 | 00 00 00 00 00 00 00 00 |..2.....|........|
|00000530| 00 00 00 00 00 00 00 00 | 00 02 00 00 00 00 00 00 |........|........|
|00000540| 00 00 04 00 00 00 00 00 | 00 00 00 04 00 00 00 00 |........|........|
|00000550| 00 00 00 00 02 00 00 00 | 00 00 00 00 00 0a 00 00 |........|........|
|00000560| 00 08 00 00 00 11 00 43 | 55 52 52 45 4e 54 5f 54 |.......C|URRENT_T|
|00000570| 49 4d 45 53 54 41 4d 50 | 11 00 43 55 52 52 45 4e |IMESTAMP|..CURREN|
|00000580| 54 5f 54 49 4d 45 53 54 | 41 4d 50 00 00 03 00 00 |T_TIMEST|AMP.....|
|00000590| 00 00 00 00 00 09 00 00 | 00 01 00 00 00 0f 00 00 |........|........|
|000005a0| 00 00 00 00 00 00 00 00 | 00 00 00 02 00 00 00 1e |........|........|
|000005b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000005e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 08 00 |........|........|
|000005f0| 00 00 0c 00 43 55 52 52 | 45 4e 54 5f 55 53 45 52 |....CURR|ENT_USER|
|00000600| 0c 00 43 55 52 52 45 4e | 54 5f 55 53 45 52 00 00 |..CURREN|T_USER..|
|00000610| 03 00 00 00 00 00 00 00 | 09 00 00 00 01 00 00 00 |........|........|
|00000620| 0f 00 00 00 00 00 00 00 | 00 00 00 00 00 00 02 00 |........|........|
|00000630| 00 00 1e 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000670| 00 08 00 00 00 10 00 46 | 69 6c 6c 20 57 69 74 68 |.......F|ill With|
|00000680| 20 53 70 61 63 65 73 00 | 00 06 00 73 70 61 63 65 | Spaces.|...space|
|00000690| 73 00 00 00 00 00 00 00 | 00 09 00 00 00 01 00 00 |s.......|........|
|000006a0| 00 0f 00 00 00 00 00 00 | 00 00 00 00 00 00 00 02 |........|........|
|000006b0| 00 00 00 1e 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006f0| 00 00 08 00 00 00 04 00 | 4e 55 4c 4c 04 00 4e 55 |........|NULL..NU|
|00000700| 4c 4c 00 00 03 00 00 00 | 00 00 00 00 09 00 00 00 |LL......|........|
|00000710| 01 00 00 00 0f 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000720| 00 00 02 00 00 00 1e 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000740| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000760| 00 00 00 00 00 08 00 00 | 00 0c 00 53 45 53 53 49 |........|...SESSI|
|00000770| 4f 4e 5f 55 53 45 52 0c | 00 53 45 53 53 49 4f 4e |ON_USER.|.SESSION|
|00000780| 5f 55 53 45 52 00 00 03 | 00 00 00 00 00 00 00 09 |_USER...|........|
|00000790| 00 00 00 01 00 00 00 0f | 00 00 00 00 00 00 00 00 |........|........|
|000007a0| 00 00 00 00 00 02 00 00 | 00 1e 00 00 00 00 00 00 |........|........|
|000007b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007e0| 00 00 00 00 00 00 00 00 | 08 00 00 00 13 00 53 65 |........|......Se|
|000007f0| 74 20 54 6f 20 45 6d 70 | 74 79 20 53 74 72 69 6e |t To Emp|ty Strin|
|00000800| 67 00 00 05 00 65 6d 70 | 74 79 00 00 00 00 00 00 |g....emp|ty......|
|00000810| 00 00 09 00 00 00 01 00 | 00 00 0f 00 00 00 00 00 |........|........|
|00000820| 00 00 00 00 00 00 00 00 | 02 00 00 00 1e 00 00 00 |........|........|
|00000830| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000840| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000850| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000860| 00 00 00 00 00 00 00 00 | 00 00 00 08 00 00 00 0b |........|........|
|00000870| 00 53 65 74 20 54 6f 20 | 4e 75 6c 6c 00 00 04 00 |.Set To |Null....|
|00000880| 6e 75 6c 6c 00 00 00 00 | 00 00 00 00 09 00 00 00 |null....|........|
|00000890| 01 00 00 00 0f 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008a0| 00 00 02 00 00 00 1e 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000008e0| 00 00 00 00 00 08 00 00 | 00 0b 00 53 65 74 20 54 |........|...Set T|
|000008f0| 6f 20 5a 65 72 6f 00 00 | 01 00 30 00 00 00 00 00 |o Zero..|..0.....|
|00000900| 00 00 00 09 00 00 00 01 | 00 00 00 0f 00 00 00 00 |........|........|
|00000910| 00 00 00 00 00 00 00 00 | 00 02 00 00 00 1e 00 00 |........|........|
|00000920| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000930| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000940| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000950| 00 00 00 00 00 00 00 00 | 00 00 00 00 08 00 00 00 |........|........|
|00000960| 04 00 55 53 45 52 04 00 | 55 53 45 52 00 00 03 00 |..USER..|USER....|
|00000970| 00 00 00 00 00 00 09 00 | 00 00 01 00 00 00 0f 00 |........|........|
|00000980| 00 00 00 00 00 00 00 00 | 00 00 00 00 02 00 00 00 |........|........|
|00000990| 1e 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000009d0| 00 00 00 00 00 05 00 00 | 00 01 00 0d 00 54 65 6d |........|.....Tem|
|000009e0| 70 6c 61 74 65 20 4e 61 | 6d 65 22 00 00 00 00 01 |plate Na|me".....|
|000009f0| 00 0d 00 54 65 6d 70 6c | 61 74 65 20 43 6f 64 65 |...Templ|ate Code|
|00000a00| 00 00 00 00 00 00 00 0d | 00 54 65 6d 70 6c 61 74 |........|.Templat|
|00000a10| 65 20 54 79 70 65 00 00 | 00 00 00 00 00 0f 00 54 |e Type..|.......T|
|00000a20| 65 6d 70 6c 61 74 65 20 | 43 53 58 20 49 64 00 00 |emplate |CSX Id..|
|00000a30| 00 00 00 02 00 00 00 00 | 00 00 00 00 23 00 00 00 |........|....#...|
|00000a40| 05 00 00 00 16 00 50 41 | 52 45 4e 54 20 55 50 44 |......PA|RENT UPD|
|00000a50| 41 54 45 20 52 45 53 54 | 52 49 43 54 f7 01 20 20 |ATE REST|RICT.. |
|00000a60| 2f 2a 20 45 52 77 69 6e | 20 42 75 69 6c 74 69 6e |/* ERwin| Builtin|
|00000a70| 20 25 44 61 74 65 74 69 | 6d 65 20 2a 2f 0d 0a 20 | %Dateti|me */.. |
|00000a80| 20 2f 2a 20 25 50 61 72 | 65 6e 74 20 25 56 65 72 | /* %Par|ent %Ver|
|00000a90| 62 50 68 72 61 73 65 20 | 25 43 68 69 6c 64 20 4f |bPhrase |%Child O|
|00000aa0| 4e 20 50 41 52 45 4e 54 | 20 55 50 44 41 54 45 20 |N PARENT| UPDATE |
|00000ab0| 52 45 53 54 52 49 43 54 | 20 2a 2f 0d 0a 20 20 69 |RESTRICT| */.. i|
|00000ac0| 66 0d 0a 20 20 20 20 2f | 2a 20 25 25 50 61 72 65 |f.. /|* %%Pare|
|00000ad0| 6e 74 50 4b 28 22 20 6f | 72 22 2c 75 70 64 61 74 |ntPK(" o|r",updat|
|00000ae0| 65 29 20 2a 2f 0d 0a 20 | 20 20 20 25 50 61 72 65 |e) */.. | %Pare|
|00000af0| 6e 74 50 4b 28 22 20 6f | 72 22 2c 75 70 64 61 74 |ntPK(" o|r",updat|
|00000b00| 65 29 0d 0a 20 20 62 65 | 67 69 6e 0d 0a 20 20 20 |e).. be|gin.. |
|00000b10| 20 69 66 20 65 78 69 73 | 74 73 20 28 0d 0a 20 20 | if exis|ts (.. |
|00000b20| 20 20 20 20 73 65 6c 65 | 63 74 20 2a 20 66 72 6f | sele|ct * fro|
|00000b30| 6d 20 64 65 6c 65 74 65 | 64 2c 25 43 68 69 6c 64 |m delete|d,%Child|
|00000b40| 0d 0a 20 20 20 20 20 20 | 77 68 65 72 65 0d 0a 20 |.. |where.. |
|00000b50| 20 20 20 20 20 20 20 2f | 2a 20 20 25 25 4a 6f 69 | /|* %%Joi|
|00000b60| 6e 46 4b 50 4b 28 25 43 | 68 69 6c 64 2c 64 65 6c |nFKPK(%C|hild,del|
|00000b70| 65 74 65 64 2c 22 20 3d | 20 22 2c 22 20 61 6e 64 |eted," =| "," and|
|00000b80| 22 29 20 2a 2f 0d 0a 20 | 20 20 20 20 20 20 20 25 |") */.. | %|
|00000b90| 4a 6f 69 6e 46 4b 50 4b | 28 25 43 68 69 6c 64 2c |JoinFKPK|(%Child,|
|00000ba0| 64 65 6c 65 74 65 64 2c | 22 20 3d 20 22 2c 22 20 |deleted,|" = "," |
|00000bb0| 61 6e 64 22 29 0d 0a 20 | 20 20 20 29 0d 0a 20 20 |and").. | ).. |
|00000bc0| 20 20 62 65 67 69 6e 0d | 0a 20 20 20 20 20 20 73 | begin.|. s|
|00000bd0| 65 6c 65 63 74 20 40 65 | 72 72 6e 6f 20 20 3d 20 |elect @e|rrno = |
|00000be0| 33 30 30 30 35 2c 0d 0a | 20 20 20 20 20 20 20 20 |30005,..| |
|00000bf0| 20 20 20 20 20 40 65 72 | 72 6d 73 67 20 3d 20 27 | @er|rmsg = '|
|00000c00| 43 61 6e 6e 6f 74 20 55 | 50 44 41 54 45 20 22 25 |Cannot U|PDATE "%|
|00000c10| 50 61 72 65 6e 74 22 20 | 62 65 63 61 75 73 65 20 |Parent" |because |
|00000c20| 22 25 43 68 69 6c 64 22 | 20 65 78 69 73 74 73 2e |"%Child"| exists.|
|00000c30| 27 0d 0a 20 20 20 20 20 | 20 67 6f 74 6f 20 65 72 |'.. | goto er|
|00000c40| 72 6f 72 0d 0a 20 20 20 | 20 65 6e 64 0d 0a 20 20 |ror.. | end.. |
|00000c50| 65 6e 64 0d 0a 10 27 00 | 00 00 00 00 00 09 00 00 |end...'.|........|
|00000c60| 00 01 00 00 00 0f 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c70| 00 00 00 02 00 00 00 1e | 00 00 00 00 00 00 00 00 |........|........|
|00000c80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000c90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ca0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000cb0| 00 00 00 00 00 00 05 00 | 00 00 15 00 50 41 52 45 |........|....PARE|
|00000cc0| 4e 54 20 55 50 44 41 54 | 45 20 43 41 53 43 41 44 |NT UPDAT|E CASCAD|
|00000cd0| 45 f1 02 20 20 2f 2a 20 | 45 52 77 69 6e 20 42 75 |E.. /* |ERwin Bu|
|00000ce0| 69 6c 74 69 6e 20 25 44 | 61 74 65 74 69 6d 65 20 |iltin %D|atetime |
|00000cf0| 2a 2f 0d 0a 20 20 2f 2a | 20 25 50 61 72 65 6e 74 |*/.. /*| %Parent|
|00000d00| 20 25 56 65 72 62 50 68 | 72 61 73 65 20 25 43 68 | %VerbPh|rase %Ch|
|00000d10| 69 6c 64 20 4f 4e 20 50 | 41 52 45 4e 54 20 55 50 |ild ON P|ARENT UP|
|00000d20| 44 41 54 45 20 43 41 53 | 43 41 44 45 20 2a 2f 0d |DATE CAS|CADE */.|
|00000d30| 0a 20 20 69 66 0d 0a 20 | 20 20 20 2f 2a 20 25 25 |. if.. | /* %%|
|00000d40| 50 61 72 65 6e 74 50 4b | 28 22 20 6f 72 22 2c 75 |ParentPK|(" or",u|
|00000d50| 70 64 61 74 65 29 20 2a | 2f 0d 0a 20 20 20 20 25 |pdate) *|/.. %|
|00000d60| 50 61 72 65 6e 74 50 4b | 28 22 20 6f 72 22 2c 75 |ParentPK|(" or",u|
|00000d70| 70 64 61 74 65 29 0d 0a | 20 20 62 65 67 69 6e 0d |pdate)..| begin.|
|00000d80| 0a 20 20 20 20 69 66 20 | 40 6e 75 6d 72 6f 77 73 |. if |@numrows|
|00000d90| 20 3d 20 31 0d 0a 20 20 | 20 20 62 65 67 69 6e 0d | = 1.. | begin.|
|00000da0| 0a 20 20 20 20 20 20 73 | 65 6c 65 63 74 20 25 4a |. s|elect %J|
|00000db0| 6f 69 6e 50 4b 50 4b 28 | 40 69 6e 73 2c 69 6e 73 |oinPKPK(|@ins,ins|
|00000dc0| 65 72 74 65 64 2c 22 20 | 3d 20 22 2c 22 2c 20 22 |erted," |= ",", "|
|00000dd0| 29 0d 0a 20 20 20 20 20 | 20 20 20 66 72 6f 6d 20 |).. | from |
|00000de0| 69 6e 73 65 72 74 65 64 | 0d 0a 20 20 20 20 20 20 |inserted|.. |
|00000df0| 75 70 64 61 74 65 20 25 | 43 68 69 6c 64 0d 0a 20 |update %|Child.. |
|00000e00| 20 20 20 20 20 73 65 74 | 0d 0a 20 20 20 20 20 20 | set|.. |
|00000e10| 20 20 2f 2a 20 20 25 25 | 4a 6f 69 6e 46 4b 50 4b | /* %%|JoinFKPK|
|00000e20| 28 25 43 68 69 6c 64 2c | 40 69 6e 73 2c 22 20 3d |(%Child,|@ins," =|
|00000e30| 20 22 2c 22 2c 22 29 20 | 2a 2f 0d 0a 20 20 20 20 | ",",") |*/.. |
|00000e40| 20 20 20 20 25 4a 6f 69 | 6e 46 4b 50 4b 28 25 43 | %Joi|nFKPK(%C|
|00000e50| 68 69 6c 64 2c 40 69 6e | 73 2c 22 20 3d 20 22 2c |hild,@in|s," = ",|
|00000e60| 22 2c 22 29 0d 0a 20 20 | 20 20 20 20 66 72 6f 6d |",").. | from|
|00000e70| 20 25 43 68 69 6c 64 2c | 69 6e 73 65 72 74 65 64 | %Child,|inserted|
|00000e80| 2c 64 65 6c 65 74 65 64 | 0d 0a 20 20 20 20 20 20 |,deleted|.. |
|00000e90| 77 68 65 72 65 0d 0a 20 | 20 20 20 20 20 20 20 2f |where.. | /|
|00000ea0| 2a 20 20 25 25 4a 6f 69 | 6e 46 4b 50 4b 28 25 43 |* %%Joi|nFKPK(%C|
|00000eb0| 68 69 6c 64 2c 64 65 6c | 65 74 65 64 2c 22 20 3d |hild,del|eted," =|
|00000ec0| 20 22 2c 22 20 61 6e 64 | 22 29 20 2a 2f 0d 0a 20 | "," and|") */.. |
|00000ed0| 20 20 20 20 20 20 20 25 | 4a 6f 69 6e 46 4b 50 4b | %|JoinFKPK|
|00000ee0| 28 25 43 68 69 6c 64 2c | 64 65 6c 65 74 65 64 2c |(%Child,|deleted,|
|00000ef0| 22 20 3d 20 22 2c 22 20 | 61 6e 64 22 29 0d 0a 20 |" = "," |and").. |
|00000f00| 20 20 20 65 6e 64 0d 0a | 20 20 20 20 65 6c 73 65 | end..| else|
|00000f10| 0d 0a 20 20 20 20 62 65 | 67 69 6e 0d 0a 20 20 20 |.. be|gin.. |
|00000f20| 20 20 20 73 65 6c 65 63 | 74 20 40 65 72 72 6e 6f | selec|t @errno|
|00000f30| 20 3d 20 33 30 30 30 36 | 2c 0d 0a 20 20 20 20 20 | = 30006|,.. |
|00000f40| 20 20 20 20 20 20 20 20 | 40 65 72 72 6d 73 67 20 | |@errmsg |
|00000f50| 3d 20 27 43 61 6e 6e 6f | 74 20 63 61 73 63 61 64 |= 'Canno|t cascad|
|00000f60| 65 20 22 25 50 61 72 65 | 6e 74 22 20 55 50 44 41 |e "%Pare|nt" UPDA|
|00000f70| 54 45 20 62 65 63 61 75 | 73 65 20 6d 6f 72 65 20 |TE becau|se more |
|00000f80| 74 68 61 6e 20 6f 6e 65 | 20 72 6f 77 20 68 61 73 |than one| row has|
|00000f90| 20 62 65 65 6e 20 61 66 | 66 65 63 74 65 64 2e 27 | been af|fected.'|
|00000fa0| 0d 0a 20 20 20 20 20 20 | 67 6f 74 6f 20 65 72 72 |.. |goto err|
|00000fb0| 6f 72 0d 0a 20 20 20 20 | 65 6e 64 0d 0a 20 20 65 |or.. |end.. e|
|00000fc0| 6e 64 0d 0a 11 27 00 00 | 00 00 00 00 09 00 00 00 |nd...'..|........|
|00000fd0| 01 00 00 00 0f 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fe0| 00 00 02 00 00 00 1e 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001000| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001020| 00 00 00 00 00 05 00 00 | 00 16 00 50 41 52 45 4e |........|...PAREN|
|00001030| 54 20 55 50 44 41 54 45 | 20 53 45 54 20 4e 55 4c |T UPDATE| SET NUL|
|00001040| 4c a4 01 20 20 2f 2a 20 | 45 52 77 69 6e 20 42 75 |L.. /* |ERwin Bu|
|00001050| 69 6c 74 69 6e 20 25 44 | 61 74 65 74 69 6d 65 20 |iltin %D|atetime |
|00001060| 2a 2f 0d 0a 20 20 2f 2a | 20 25 50 61 72 65 6e 74 |*/.. /*| %Parent|
|00001070| 20 25 56 65 72 62 50 68 | 72 61 73 65 20 25 43 68 | %VerbPh|rase %Ch|
|00001080| 69 6c 64 20 4f 4e 20 50 | 41 52 45 4e 54 20 55 50 |ild ON P|ARENT UP|
|00001090| 44 41 54 45 20 53 45 54 | 20 4e 55 4c 4c 20 2a 2f |DATE SET| NULL */|
|000010a0| 0d 0a 20 20 69 66 0d 0a | 20 20 20 20 2f 2a 20 25 |.. if..| /* %|
|000010b0| 25 50 61 72 65 6e 74 50 | 4b 28 22 20 6f 72 22 2c |%ParentP|K(" or",|
|000010c0| 75 70 64 61 74 65 29 20 | 2a 2f 0d 0a 20 20 20 20 |update) |*/.. |
|000010d0| 25 50 61 72 65 6e 74 50 | 4b 28 22 20 6f 72 22 2c |%ParentP|K(" or",|
|000010e0| 75 70 64 61 74 65 29 0d | 0a 20 20 62 65 67 69 6e |update).|. begin|
|000010f0| 0d 0a 20 20 20 20 75 70 | 64 61 74 65 20 25 43 68 |.. up|date %Ch|
|00001100| 69 6c 64 0d 0a 20 20 20 | 20 20 20 73 65 74 0d 0a |ild.. | set..|
|00001110| 20 20 20 20 20 20 20 20 | 2f 2a 20 25 25 53 65 74 | |/* %%Set|
|00001120| 46 4b 28 25 43 68 69 6c | 64 2c 4e 55 4c 4c 29 20 |FK(%Chil|d,NULL) |
|00001130| 2a 2f 0d 0a 20 20 20 20 | 20 20 20 20 25 53 65 74 |*/.. | %Set|
|00001140| 46 4b 28 25 43 68 69 6c | 64 2c 4e 55 4c 4c 29 0d |FK(%Chil|d,NULL).|
|00001150| 0a 20 20 20 20 20 20 66 | 72 6f 6d 20 25 43 68 69 |. f|rom %Chi|
|00001160| 6c 64 2c 64 65 6c 65 74 | 65 64 0d 0a 20 20 20 20 |ld,delet|ed.. |
|00001170| 20 20 77 68 65 72 65 0d | 0a 20 20 20 20 20 20 20 | where.|. |
|00001180| 20 2f 2a 20 25 25 4a 6f | 69 6e 46 4b 50 4b 28 25 | /* %%Jo|inFKPK(%|
|00001190| 43 68 69 6c 64 2c 64 65 | 6c 65 74 65 64 2c 22 20 |Child,de|leted," |
|000011a0| 3d 20 22 2c 22 20 61 6e | 64 22 29 20 2a 2f 0d 0a |= "," an|d") */..|
|000011b0| 20 20 20 20 20 20 20 20 | 25 4a 6f 69 6e 46 4b 50 | |%JoinFKP|
|000011c0| 4b 28 25 43 68 69 6c 64 | 2c 64 65 6c 65 74 65 64 |K(%Child|,deleted|
|000011d0| 2c 22 20 3d 20 22 2c 22 | 20 61 6e 64 22 29 0d 0a |," = ","| and")..|
|000011e0| 20 20 65 6e 64 0d 0a 12 | 27 00 00 00 00 00 00 09 | end...|'.......|
|000011f0| 00 00 00 01 00 00 00 0f | 00 00 00 00 00 00 00 00 |........|........|
|00001200| 00 00 00 00 00 02 00 00 | 00 1e 00 00 00 00 00 00 |........|........|
|00001210| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001220| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001230| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001240| 00 00 00 00 00 00 00 00 | 05 00 00 00 16 00 50 41 |........|......PA|
|00001250| 52 45 4e 54 20 44 45 4c | 45 54 45 20 52 45 53 54 |RENT DEL|ETE REST|
|00001260| 52 49 43 54 a4 01 20 20 | 20 20 2f 2a 20 45 52 77 |RICT.. | /* ERw|
|00001270| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|00001280| 74 69 6d 65 20 2a 2f 0d | 0a 20 20 20 20 2f 2a 20 |time */.|. /* |
|00001290| 25 50 61 72 65 6e 74 20 | 25 56 65 72 62 50 68 72 |%Parent |%VerbPhr|
|000012a0| 61 73 65 20 25 43 68 69 | 6c 64 20 4f 4e 20 50 41 |ase %Chi|ld ON PA|
|000012b0| 52 45 4e 54 20 44 45 4c | 45 54 45 20 52 45 53 54 |RENT DEL|ETE REST|
|000012c0| 52 49 43 54 20 2a 2f 0d | 0a 20 20 20 20 69 66 20 |RICT */.|. if |
|000012d0| 65 78 69 73 74 73 20 28 | 0d 0a 20 20 20 20 20 20 |exists (|.. |
|000012e0| 73 65 6c 65 63 74 20 2a | 20 66 72 6f 6d 20 64 65 |select *| from de|
|000012f0| 6c 65 74 65 64 2c 25 43 | 68 69 6c 64 0d 0a 20 20 |leted,%C|hild.. |
|00001300| 20 20 20 20 77 68 65 72 | 65 0d 0a 20 20 20 20 20 | wher|e.. |
|00001310| 20 20 20 2f 2a 20 20 25 | 25 4a 6f 69 6e 46 4b 50 | /* %|%JoinFKP|
|00001320| 4b 28 25 43 68 69 6c 64 | 2c 64 65 6c 65 74 65 64 |K(%Child|,deleted|
|00001330| 2c 22 20 3d 20 22 2c 22 | 20 61 6e 64 22 29 20 2a |," = ","| and") *|
|00001340| 2f 0d 0a 20 20 20 20 20 | 20 20 20 25 4a 6f 69 6e |/.. | %Join|
|00001350| 46 4b 50 4b 28 25 43 68 | 69 6c 64 2c 64 65 6c 65 |FKPK(%Ch|ild,dele|
|00001360| 74 65 64 2c 22 20 3d 20 | 22 2c 22 20 61 6e 64 22 |ted," = |"," and"|
|00001370| 29 0d 0a 20 20 20 20 29 | 0d 0a 20 20 20 20 62 65 |).. )|.. be|
|00001380| 67 69 6e 0d 0a 20 20 20 | 20 20 20 73 65 6c 65 63 |gin.. | selec|
|00001390| 74 20 40 65 72 72 6e 6f | 20 20 3d 20 33 30 30 30 |t @errno| = 3000|
|000013a0| 31 2c 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |1,.. | |
|000013b0| 20 40 65 72 72 6d 73 67 | 20 3d 20 27 43 61 6e 6e | @errmsg| = 'Cann|
|000013c0| 6f 74 20 44 45 4c 45 54 | 45 20 22 25 50 61 72 65 |ot DELET|E "%Pare|
|000013d0| 6e 74 22 20 62 65 63 61 | 75 73 65 20 22 25 43 68 |nt" beca|use "%Ch|
|000013e0| 69 6c 64 22 20 65 78 69 | 73 74 73 2e 27 0d 0a 20 |ild" exi|sts.'.. |
|000013f0| 20 20 20 20 20 67 6f 74 | 6f 20 65 72 72 6f 72 0d | got|o error.|
|00001400| 0a 20 20 20 20 65 6e 64 | 0d 0a 14 27 00 00 00 00 |. end|...'....|
|00001410| 00 00 09 00 00 00 01 00 | 00 00 0f 00 00 00 00 00 |........|........|
|00001420| 00 00 00 00 00 00 00 00 | 02 00 00 00 1e 00 00 00 |........|........|
|00001430| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001440| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001450| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001460| 00 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 15 |........|........|
|00001470| 00 50 41 52 45 4e 54 20 | 44 45 4c 45 54 45 20 43 |.PARENT |DELETE C|
|00001480| 41 53 43 41 44 45 05 01 | 20 20 20 20 2f 2a 20 45 |ASCADE..| /* E|
|00001490| 52 77 69 6e 20 42 75 69 | 6c 74 69 6e 20 25 44 61 |Rwin Bui|ltin %Da|
|000014a0| 74 65 74 69 6d 65 20 2a | 2f 0d 0a 20 20 20 20 2f |tetime *|/.. /|
|000014b0| 2a 20 25 50 61 72 65 6e | 74 20 25 56 65 72 62 50 |* %Paren|t %VerbP|
|000014c0| 68 72 61 73 65 20 25 43 | 68 69 6c 64 20 4f 4e 20 |hrase %C|hild ON |
|000014d0| 50 41 52 45 4e 54 20 44 | 45 4c 45 54 45 20 43 41 |PARENT D|ELETE CA|
|000014e0| 53 43 41 44 45 20 2a 2f | 0d 0a 20 20 20 20 64 65 |SCADE */|.. de|
|000014f0| 6c 65 74 65 20 25 43 68 | 69 6c 64 0d 0a 20 20 20 |lete %Ch|ild.. |
|00001500| 20 20 20 66 72 6f 6d 20 | 25 43 68 69 6c 64 2c 64 | from |%Child,d|
|00001510| 65 6c 65 74 65 64 0d 0a | 20 20 20 20 20 20 77 68 |eleted..| wh|
|00001520| 65 72 65 0d 0a 20 20 20 | 20 20 20 20 20 2f 2a 20 |ere.. | /* |
|00001530| 20 25 25 4a 6f 69 6e 46 | 4b 50 4b 28 25 43 68 69 | %%JoinF|KPK(%Chi|
|00001540| 6c 64 2c 64 65 6c 65 74 | 65 64 2c 22 20 3d 20 22 |ld,delet|ed," = "|
|00001550| 2c 22 20 61 6e 64 22 29 | 20 2a 2f 0d 0a 20 20 20 |," and")| */.. |
|00001560| 20 20 20 20 20 25 4a 6f | 69 6e 46 4b 50 4b 28 25 | %Jo|inFKPK(%|
|00001570| 43 68 69 6c 64 2c 64 65 | 6c 65 74 65 64 2c 22 20 |Child,de|leted," |
|00001580| 3d 20 22 2c 22 20 61 6e | 64 22 29 0d 0a 15 27 00 |= "," an|d")...'.|
|00001590| 00 00 00 00 00 09 00 00 | 00 01 00 00 00 0f 00 00 |........|........|
|000015a0| 00 00 00 00 00 00 00 00 | 00 00 00 02 00 00 00 1e |........|........|
|000015b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000015e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 05 00 |........|........|
|000015f0| 00 00 16 00 50 41 52 45 | 4e 54 20 44 45 4c 45 54 |....PARE|NT DELET|
|00001600| 45 20 53 45 54 20 4e 55 | 4c 4c 51 01 20 20 20 20 |E SET NU|LLQ. |
|00001610| 2f 2a 20 45 52 77 69 6e | 20 42 75 69 6c 74 69 6e |/* ERwin| Builtin|
|00001620| 20 25 44 61 74 65 74 69 | 6d 65 20 2a 2f 0d 0a 20 | %Dateti|me */.. |
|00001630| 20 20 20 2f 2a 20 25 50 | 61 72 65 6e 74 20 25 56 | /* %P|arent %V|
|00001640| 65 72 62 50 68 72 61 73 | 65 20 25 43 68 69 6c 64 |erbPhras|e %Child|
|00001650| 20 4f 4e 20 50 41 52 45 | 4e 54 20 44 45 4c 45 54 | ON PARE|NT DELET|
|00001660| 45 20 53 45 54 20 4e 55 | 4c 4c 20 2a 2f 0d 0a 20 |E SET NU|LL */.. |
|00001670| 20 20 20 75 70 64 61 74 | 65 20 25 43 68 69 6c 64 | updat|e %Child|
|00001680| 0d 0a 20 20 20 20 20 20 | 73 65 74 0d 0a 20 20 20 |.. |set.. |
|00001690| 20 20 20 20 20 2f 2a 20 | 25 25 53 65 74 46 4b 28 | /* |%%SetFK(|
|000016a0| 25 43 68 69 6c 64 2c 4e | 55 4c 4c 29 20 2a 2f 0d |%Child,N|ULL) */.|
|000016b0| 0a 20 20 20 20 20 20 20 | 20 25 53 65 74 46 4b 28 |. | %SetFK(|
|000016c0| 25 43 68 69 6c 64 2c 4e | 55 4c 4c 29 0d 0a 20 20 |%Child,N|ULL).. |
|000016d0| 20 20 20 20 66 72 6f 6d | 20 25 43 68 69 6c 64 2c | from| %Child,|
|000016e0| 64 65 6c 65 74 65 64 0d | 0a 20 20 20 20 20 20 77 |deleted.|. w|
|000016f0| 68 65 72 65 0d 0a 20 20 | 20 20 20 20 20 20 2f 2a |here.. | /*|
|00001700| 20 25 25 4a 6f 69 6e 46 | 4b 50 4b 28 25 43 68 69 | %%JoinF|KPK(%Chi|
|00001710| 6c 64 2c 64 65 6c 65 74 | 65 64 2c 22 20 3d 20 22 |ld,delet|ed," = "|
|00001720| 2c 22 20 61 6e 64 22 29 | 20 2a 2f 0d 0a 20 20 20 |," and")| */.. |
|00001730| 20 20 20 20 20 25 4a 6f | 69 6e 46 4b 50 4b 28 25 | %Jo|inFKPK(%|
|00001740| 43 68 69 6c 64 2c 64 65 | 6c 65 74 65 64 2c 22 20 |Child,de|leted," |
|00001750| 3d 20 22 2c 22 20 61 6e | 64 22 29 0d 0a 16 27 00 |= "," an|d")...'.|
|00001760| 00 00 00 00 00 09 00 00 | 00 01 00 00 00 0f 00 00 |........|........|
|00001770| 00 00 00 00 00 00 00 00 | 00 00 00 02 00 00 00 1e |........|........|
|00001780| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 05 00 |........|........|
|000017c0| 00 00 15 00 43 48 49 4c | 44 20 49 4e 53 45 52 54 |....CHIL|D INSERT|
|000017d0| 20 52 45 53 54 52 49 43 | 54 f0 02 20 20 2f 2a 20 | RESTRIC|T.. /* |
|000017e0| 45 52 77 69 6e 20 42 75 | 69 6c 74 69 6e 20 25 44 |ERwin Bu|iltin %D|
|000017f0| 61 74 65 74 69 6d 65 20 | 2a 2f 0d 0a 20 20 2f 2a |atetime |*/.. /*|
|00001800| 20 25 50 61 72 65 6e 74 | 20 25 56 65 72 62 50 68 | %Parent| %VerbPh|
|00001810| 72 61 73 65 20 25 43 68 | 69 6c 64 20 4f 4e 20 43 |rase %Ch|ild ON C|
|00001820| 48 49 4c 44 20 49 4e 53 | 45 52 54 20 52 45 53 54 |HILD INS|ERT REST|
|00001830| 52 49 43 54 20 2a 2f 0d | 0a 20 20 69 66 0d 0a 20 |RICT */.|. if.. |
|00001840| 20 20 20 2f 2a 20 25 25 | 43 68 69 6c 64 46 4b 28 | /* %%|ChildFK(|
|00001850| 22 20 6f 72 22 2c 75 70 | 64 61 74 65 29 20 2a 2f |" or",up|date) */|
|00001860| 0d 0a 20 20 20 20 25 43 | 68 69 6c 64 46 4b 28 22 |.. %C|hildFK("|
|00001870| 20 6f 72 22 2c 75 70 64 | 61 74 65 29 0d 0a 20 20 | or",upd|ate).. |
|00001880| 62 65 67 69 6e 0d 0a 20 | 20 20 20 73 65 6c 65 63 |begin.. | selec|
|00001890| 74 20 40 6e 75 6c 6c 63 | 6e 74 20 3d 20 30 0d 0a |t @nullc|nt = 0..|
|000018a0| 20 20 20 20 73 65 6c 65 | 63 74 20 40 76 61 6c 69 | sele|ct @vali|
|000018b0| 64 63 6e 74 20 3d 20 63 | 6f 75 6e 74 28 2a 29 0d |dcnt = c|ount(*).|
|000018c0| 0a 20 20 20 20 20 20 66 | 72 6f 6d 20 69 6e 73 65 |. f|rom inse|
|000018d0| 72 74 65 64 2c 25 50 61 | 72 65 6e 74 0d 0a 20 20 |rted,%Pa|rent.. |
|000018e0| 20 20 20 20 20 20 77 68 | 65 72 65 0d 0a 20 20 20 | wh|ere.. |
|000018f0| 20 20 20 20 20 20 20 2f | 2a 20 25 25 4a 6f 69 6e | /|* %%Join|
|00001900| 46 4b 50 4b 28 69 6e 73 | 65 72 74 65 64 2c 25 50 |FKPK(ins|erted,%P|
|00001910| 61 72 65 6e 74 29 20 2a | 2f 0d 0a 20 20 20 20 20 |arent) *|/.. |
|00001920| 20 20 20 20 20 25 4a 6f | 69 6e 46 4b 50 4b 28 69 | %Jo|inFKPK(i|
|00001930| 6e 73 65 72 74 65 64 2c | 25 50 61 72 65 6e 74 29 |nserted,|%Parent)|
|00001940| 0d 0a 20 20 20 20 2f 2a | 20 25 25 4e 6f 74 6e 75 |.. /*| %%Notnu|
|00001950| 6c 6c 46 4b 28 69 6e 73 | 65 72 74 65 64 2c 22 20 |llFK(ins|erted," |
|00001960| 69 73 20 6e 75 6c 6c 22 | 2c 22 73 65 6c 65 63 74 |is null"|,"select|
|00001970| 20 40 6e 75 6c 6c 63 6e | 74 20 3d 20 63 6f 75 6e | @nullcn|t = coun|
|00001980| 74 28 2a 29 20 66 72 6f | 6d 20 69 6e 73 65 72 74 |t(*) fro|m insert|
|00001990| 65 64 20 77 68 65 72 65 | 22 2c 22 20 61 6e 64 22 |ed where|"," and"|
|000019a0| 29 20 2a 2f 0d 0a 20 20 | 20 20 25 4e 6f 74 6e 75 |) */.. | %Notnu|
|000019b0| 6c 6c 46 4b 28 69 6e 73 | 65 72 74 65 64 2c 22 20 |llFK(ins|erted," |
|000019c0| 69 73 20 6e 75 6c 6c 22 | 2c 22 73 65 6c 65 63 74 |is null"|,"select|
|000019d0| 20 40 6e 75 6c 6c 63 6e | 74 20 3d 20 63 6f 75 6e | @nullcn|t = coun|
|000019e0| 74 28 2a 29 20 66 72 6f | 6d 20 69 6e 73 65 72 74 |t(*) fro|m insert|
|000019f0| 65 64 20 77 68 65 72 65 | 22 2c 22 20 61 6e 64 22 |ed where|"," and"|
|00001a00| 29 0d 0a 20 20 20 20 69 | 66 20 40 76 61 6c 69 64 |).. i|f @valid|
|00001a10| 63 6e 74 20 2b 20 40 6e | 75 6c 6c 63 6e 74 20 21 |cnt + @n|ullcnt !|
|00001a20| 3d 20 40 6e 75 6d 72 6f | 77 73 0d 0a 20 20 20 20 |= @numro|ws.. |
|00001a30| 62 65 67 69 6e 0d 0a 20 | 20 20 20 20 20 73 65 6c |begin.. | sel|
|00001a40| 65 63 74 20 40 65 72 72 | 6e 6f 20 20 3d 20 33 30 |ect @err|no = 30|
|00001a50| 30 30 32 2c 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |002,.. | |
|00001a60| 20 20 20 40 65 72 72 6d | 73 67 20 3d 20 27 43 61 | @errm|sg = 'Ca|
|00001a70| 6e 6e 6f 74 20 49 4e 53 | 45 52 54 20 22 25 43 68 |nnot INS|ERT "%Ch|
|00001a80| 69 6c 64 22 20 62 65 63 | 61 75 73 65 20 22 25 50 |ild" bec|ause "%P|
|00001a90| 61 72 65 6e 74 22 20 64 | 6f 65 73 20 6e 6f 74 20 |arent" d|oes not |
|00001aa0| 65 78 69 73 74 2e 27 0d | 0a 20 20 20 20 20 20 67 |exist.'.|. g|
|00001ab0| 6f 74 6f 20 65 72 72 6f | 72 0d 0a 20 20 20 20 65 |oto erro|r.. e|
|00001ac0| 6e 64 0d 0a 20 20 65 6e | 64 0d 0a 18 27 00 00 00 |nd.. en|d...'...|
|00001ad0| 00 00 00 09 00 00 00 01 | 00 00 00 0f 00 00 00 00 |........|........|
|00001ae0| 00 00 00 00 00 00 00 00 | 00 02 00 00 00 1e 00 00 |........|........|
|00001af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001b20| 00 00 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |........|........|
|00001b30| 14 00 43 48 49 4c 44 20 | 49 4e 53 45 52 54 20 43 |..CHILD |INSERT C|
|00001b40| 41 53 43 41 44 45 48 02 | 20 20 2f 2a 20 45 52 77 |ASCADEH.| /* ERw|
|00001b50| 69 6e 20 42 75 69 6c 74 | 69 6e 20 25 44 61 74 65 |in Built|in %Date|
|00001b60| 74 69 6d 65 20 2a 2f 0d | 0a 20 20 2f 2a 20 25 50 |time */.|. /* %P|
|00001b70| 61 72 65 6e 74 20 25 56 | 65 72 62 50 68 72 61 73 |arent %V|erbPhras|
|00001b80| 65 20 25 43 68 69 6c 64 | 20 4f 4e 20 43 48 49 4c |e %Child| ON CHIL|
|00001b90| 44 20 49 4e 53 45 52 54 | 20 43 41 53 43 41 44 45 |D INSERT| CASCADE|
|00001ba0| 20 2a 2f 0d 0a 20 20 69 | 66 0d 0a 20 20 20 20 2f | */.. i|f.. /|
|00001bb0| 2a 20 25 25 43 68 69 6c | 64 46 4b 28 22 20 6f 72 |* %%Chil|dFK(" or|
|00001bc0| 22 2c 75 70 64 61 74 65 | 29 20 2a 2f 0d 0a 20 20 |",update|) */.. |
|00001bd0| 20 20 25 43 68 69 6c 64 | 46 4b 28 22 20 6f 72 22 | %Child|FK(" or"|
|00001be0| 2c 75 70 64 61 74 65 29 | 0d 0a 20 20 62 65 67 69 |,update)|.. begi|
|00001bf0| 6e 0d 0a 20 20 20 20 69 | 6e 73 65 72 74 20 25 50 |n.. i|nsert %P|
|00001c00| 61 72 65 6e 74 20 28 25 | 50 61 72 65 6e 74 50 4b |arent (%|ParentPK|
|00001c10| 28 22 2c 22 2c 29 29 0d | 0a 20 20 20 20 20 20 73 |(",",)).|. s|
|00001c20| 65 6c 65 63 74 20 25 43 | 68 69 6c 64 46 4b 28 22 |elect %C|hildFK("|
|00001c30| 2c 22 2c 29 0d 0a 20 20 | 20 20 20 20 66 72 6f 6d |,",).. | from|
|00001c40| 20 20 20 69 6e 73 65 72 | 74 65 64 0d 0a 20 20 20 | inser|ted.. |
|00001c50| 20 20 20 77 68 65 72 65 | 0d 0a 20 20 20 20 20 20 | where|.. |
|00001c60| 20 20 2f 2a 20 25 25 4e | 6f 74 6e 75 6c 6c 46 4b | /* %%N|otnullFK|
|00001c70| 28 69 6e 73 65 72 74 65 | 64 2c 22 20 69 73 20 6e |(inserte|d," is n|
|00001c80| 6f 74 20 6e 75 6c 6c 20 | 61 6e 64 22 29 20 2a 2f |ot null |and") */|
|00001c90| 0d 0a 20 20 20 20 20 20 | 20 20 25 4e 6f 74 6e 75 |.. | %Notnu|
|00001ca0| 6c 6c 46 4b 28 69 6e 73 | 65 72 74 65 64 2c 22 20 |llFK(ins|erted," |
|00001cb0| 69 73 20 6e 6f 74 20 6e | 75 6c 6c 20 61 6e 64 22 |is not n|ull and"|
|00001cc0| 29 0d 0a 20 20 20 20 20 | 20 20 20 6e 6f 74 20 65 |).. | not e|
|00001cd0| 78 69 73 74 73 20 28 0d | 0a 20 20 20 20 20 20 20 |xists (.|. |
|00001ce0| 20 20 20 73 65 6c 65 63 | 74 20 2a 20 66 72 6f 6d | selec|t * from|
|00001cf0| 20 25 50 61 72 65 6e 74 | 0d 0a 20 20 20 20 20 20 | %Parent|.. |
|00001d00| 20 20 20 20 77 68 65 72 | 65 0d 0a 20 20 20 20 20 | wher|e.. |
|00001d10| 20 20 20 20 20 20 20 2f | 2a 20 25 25 4a 6f 69 6e | /|* %%Join|
|00001d20| 46 4b 50 4b 28 69 6e 73 | 65 72 74 65 64 2c 25 50 |FKPK(ins|erted,%P|
|00001d30| 61 72 65 6e 74 2c 22 20 | 3d 20 22 2c 22 20 61 6e |arent," |= "," an|
|00001d40| 64 22 29 20 2a 2f 0d 0a | 20 20 20 20 20 20 20 20 |d") */..| |
|00001d50| 20 20 20 20 25 4a 6f 69 | 6e 46 4b 50 4b 28 69 6e | %Joi|nFKPK(in|
|00001d60| 73 65 72 74 65 64 2c 25 | 50 61 72 65 6e 74 2c 22 |serted,%|Parent,"|
|00001d70| 20 3d 20 22 2c 22 20 61 | 6e 64 22 29 0d 0a 20 20 | = "," a|nd").. |
|00001d80| 20 20 20 20 20 20 29 0d | 0a 20 20 65 6e 64 0d 0a | ).|. end..|
|00001d90| 19 27 00 00 00 00 00 00 | 09 00 00 00 01 00 00 00 |.'......|........|
|00001da0| 0f 00 00 00 00 00 00 00 | 00 00 00 00 00 00 02 00 |........|........|
|00001db0| 00 00 1e 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001dc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001dd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001de0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001df0| 00 05 00 00 00 14 00 43 | 48 49 4c 44 20 49 4e 53 |.......C|HILD INS|
|00001e00| 45 52 54 20 53 45 54 4e | 55 4c 4c 6e 02 20 20 2f |ERT SETN|ULLn. /|
|00001e10| 2a 20 45 52 77 69 6e 20 | 42 75 69 6c 74 69 6e 20 |* ERwin |Builtin |
|00001e20| 25 44 61 74 65 74 69 6d | 65 20 2a 2f 0d 0a 20 20 |%Datetim|e */.. |
|00001e30| 2f 2a 20 25 50 61 72 65 | 6e 74 20 25 56 65 72 62 |/* %Pare|nt %Verb|
|00001e40| 50 68 72 61 73 65 20 25 | 43 68 69 6c 64 20 4f 4e |Phrase %|Child ON|
|00001e50| 20 43 48 49 4c 44 20 49 | 4e 53 45 52 54 20 53 45 | CHILD I|NSERT SE|
|00001e60| 54 20 4e 55 4c 4c 20 2a | 2f 0d 0a 20 20 69 66 0d |T NULL *|/.. if.|
|00001e70| 0a 20 20 20 20 2f 2a 20 | 25 25 43 68 69 6c 64 46 |. /* |%%ChildF|
|00001e80| 4b 28 22 20 6f 72 22 2c | 75 70 64 61 74 65 29 20 |K(" or",|update) |
|00001e90| 2a 2f 0d 0a 20 20 20 20 | 25 43 68 69 6c 64 46 4b |*/.. |%ChildFK|
|00001ea0| 28 22 20 6f 72 22 2c 75 | 70 64 61 74 65 29 0d 0a |(" or",u|pdate)..|
|00001eb0| 20 20 62 65 67 69 6e 0d | 0a 20 20 20 20 75 70 64 | begin.|. upd|
|00001ec0| 61 74 65 20 25 43 68 69 | 6c 64 0d 0a 20 20 20 20 |ate %Chi|ld.. |
|00001ed0| 20 20 73 65 74 0d 0a 20 | 20 20 20 20 20 20 20 2f | set.. | /|
|00001ee0| 2a 20 25 25 53 65 74 46 | 4b 28 25 43 68 69 6c 64 |* %%SetF|K(%Child|
|00001ef0| 2c 4e 55 4c 4c 29 20 2a | 2f 0d 0a 20 20 20 20 20 |,NULL) *|/.. |
|00001f00| 20 20 20 25 53 65 74 46 | 4b 28 25 43 68 69 6c 64 | %SetF|K(%Child|
|00001f10| 2c 4e 55 4c 4c 29 0d 0a | 20 20 20 20 20 20 66 72 |,NULL)..| fr|
|00001f20| 6f 6d 20 25 43 68 69 6c | 64 2c 69 6e 73 65 72 74 |om %Chil|d,insert|
|00001f30| 65 64 0d 0a 20 20 20 20 | 20 20 77 68 65 72 65 0d |ed.. | where.|
|00001f40| 0a 20 20 20 20 20 20 20 | 20 2f 2a 20 25 25 4a 6f |. | /* %%Jo|
|00001f50| 69 6e 50 4b 50 4b 28 25 | 43 68 69 6c 64 2c 69 6e |inPKPK(%|Child,in|
|00001f60| 73 65 72 74 65 64 2c 22 | 20 3d 20 22 2c 22 20 61 |serted,"| = "," a|
|00001f70| 6e 64 22 29 20 2a 2f 0d | 0a 20 20 20 20 20 20 20 |nd") */.|. |
|00001f80| 20 25 4a 6f 69 6e 50 4b | 50 4b 28 25 43 68 69 6c | %JoinPK|PK(%Chil|
|00001f90| 64 2c 69 6e 73 65 72 74 | 65 64 2c 22 20 3d 20 22 |d,insert|ed," = "|
|00001fa0| 2c 22 20 61 6e 64 22 29 | 20 61 6e 64 0d 0a 20 20 |," and")| and.. |
|00001fb0| 20 20 20 20 20 20 6e 6f | 74 20 65 78 69 73 74 73 | no|t exists|
|00001fc0| 20 28 0d 0a 20 20 20 20 | 20 20 20 20 20 20 73 65 | (.. | se|
|00001fd0| 6c 65 63 74 20 2a 20 66 | 72 6f 6d 20 25 50 61 72 |lect * f|rom %Par|
|00001fe0| 65 6e 74 0d 0a 20 20 20 | 20 20 20 20 20 20 20 77 |ent.. | w|
|00001ff0| 68 65 72 65 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |here.. | |
|00002000| 20 20 2f 2a 20 25 25 4a | 6f 69 6e 46 4b 50 4b 28 | /* %%J|oinFKPK(|
|00002010| 69 6e 73 65 72 74 65 64 | 2c 25 50 61 72 65 6e 74 |inserted|,%Parent|
|00002020| 2c 22 20 3d 20 22 2c 22 | 20 61 6e 64 22 29 20 2a |," = ","| and") *|
|00002030| 2f 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 20 25 |/.. | %|
|00002040| 4a 6f 69 6e 46 4b 50 4b | 28 69 6e 73 65 72 74 65 |JoinFKPK|(inserte|
|00002050| 64 2c 25 50 61 72 65 6e | 74 2c 22 20 3d 20 22 2c |d,%Paren|t," = ",|
|00002060| 22 20 61 6e 64 22 29 0d | 0a 20 20 20 20 20 20 20 |" and").|. |
|00002070| 20 29 0d 0a 20 20 65 6e | 64 0d 0a 1a 27 00 00 00 | ).. en|d...'...|
|00002080| 00 00 00 09 00 00 00 01 | 00 00 00 0f 00 00 00 00 |........|........|
|00002090| 00 00 00 00 00 00 00 00 | 00 02 00 00 00 1e 00 00 |........|........|
|000020a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000020b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000020c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000020d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 05 00 00 00 |........|........|
|000020e0| 15 00 43 48 49 4c 44 20 | 55 50 44 41 54 45 20 52 |..CHILD |UPDATE R|
|000020f0| 45 53 54 52 49 43 54 f0 | 02 20 20 2f 2a 20 45 52 |ESTRICT.|. /* ER|
|00002100| 77 69 6e 20 42 75 69 6c | 74 69 6e 20 25 44 61 74 |win Buil|tin %Dat|
|00002110| 65 74 69 6d 65 20 2a 2f | 0d 0a 20 20 2f 2a 20 25 |etime */|.. /* %|
|00002120| 50 61 72 65 6e 74 20 25 | 56 65 72 62 50 68 72 61 |Parent %|VerbPhra|
|00002130| 73 65 20 25 43 68 69 6c | 64 20 4f 4e 20 43 48 49 |se %Chil|d ON CHI|
|00002140| 4c 44 20 55 50 44 41 54 | 45 20 52 45 53 54 52 49 |LD UPDAT|E RESTRI|
|00002150| 43 54 20 2a 2f 0d 0a 20 | 20 69 66 0d 0a 20 20 20 |CT */.. | if.. |
|00002160| 20 2f 2a 20 25 25 43 68 | 69 6c 64 46 4b 28 22 20 | /* %%Ch|ildFK(" |
|00002170| 6f 72 22 2c 75 70 64 61 | 74 65 29 20 2a 2f 0d 0a |or",upda|te) */..|
|00002180| 20 20 20 20 25 43 68 69 | 6c 64 46 4b 28 22 20 6f | %Chi|ldFK(" o|
|00002190| 72 22 2c 75 70 64 61 74 | 65 29 0d 0a 20 20 62 65 |r",updat|e).. be|
|000021a0| 67 69 6e 0d 0a 20 20 20 | 20 73 65 6c 65 63 74 20 |gin.. | select |
|000021b0| 40 6e 75 6c 6c 63 6e 74 | 20 3d 20 30 0d 0a 20 20 |@nullcnt| = 0.. |
|000021c0| 20 20 73 65 6c 65 63 74 | 20 40 76 61 6c 69 64 63 | select| @validc|
|000021d0| 6e 74 20 3d 20 63 6f 75 | 6e 74 28 2a 29 0d 0a 20 |nt = cou|nt(*).. |
|000021e0| 20 20 20 20 20 66 72 6f | 6d 20 69 6e 73 65 72 74 | fro|m insert|
|000021f0| 65 64 2c 25 50 61 72 65 | 6e 74 0d 0a 20 20 20 20 |ed,%Pare|nt.. |
|00002200| 20 20 20 20 77 68 65 72 | 65 0d 0a 20 20 20 20 20 | wher|e.. |
|00002210| 20 20 20 20 20 2f 2a 20 | 25 25 4a 6f 69 6e 46 4b | /* |%%JoinFK|
|00002220| 50 4b 28 69 6e 73 65 72 | 74 65 64 2c 25 50 61 72 |PK(inser|ted,%Par|
|00002230| 65 6e 74 29 20 2a 2f 0d | 0a 20 20 20 20 20 20 20 |ent) */.|. |
|00002240| 20 20 20 25 4a 6f 69 6e | 46 4b 50 4b 28 69 6e 73 | %Join|FKPK(ins|
|00002250| 65 72 74 65 64 2c 25 50 | 61 72 65 6e 74 29 0d 0a |erted,%P|arent)..|
|00002260| 20 20 20 20 2f 2a 20 25 | 25 4e 6f 74 6e 75 6c 6c | /* %|%Notnull|
|00002270| 46 4b 28 69 6e 73 65 72 | 74 65 64 2c 22 20 69 73 |FK(inser|ted," is|
|00002280| 20 6e 75 6c 6c 22 2c 22 | 73 65 6c 65 63 74 20 40 | null","|select @|
|00002290| 6e 75 6c 6c 63 6e 74 20 | 3d 20 63 6f 75 6e 74 28 |nullcnt |= count(|
|000022a0| 2a 29 20 66 72 6f 6d 20 | 69 6e 73 65 72 74 65 64 |*) from |inserted|
|000022b0| 20 77 68 65 72 65 22 2c | 22 20 61 6e 64 22 29 20 | where",|" and") |
|000022c0| 2a 2f 0d 0a 20 20 20 20 | 25 4e 6f 74 6e 75 6c 6c |*/.. |%Notnull|
|000022d0| 46 4b 28 69 6e 73 65 72 | 74 65 64 2c 22 20 69 73 |FK(inser|ted," is|
|000022e0| 20 6e 75 6c 6c 22 2c 22 | 73 65 6c 65 63 74 20 40 | null","|select @|
|000022f0| 6e 75 6c 6c 63 6e 74 20 | 3d 20 63 6f 75 6e 74 28 |nullcnt |= count(|
|00002300| 2a 29 20 66 72 6f 6d 20 | 69 6e 73 65 72 74 65 64 |*) from |inserted|
|00002310| 20 77 68 65 72 65 22 2c | 22 20 61 6e 64 22 29 0d | where",|" and").|
|00002320| 0a 20 20 20 20 69 66 20 | 40 76 61 6c 69 64 63 6e |. if |@validcn|
|00002330| 74 20 2b 20 40 6e 75 6c | 6c 63 6e 74 20 21 3d 20 |t + @nul|lcnt != |
|00002340| 40 6e 75 6d 72 6f 77 73 | 0d 0a 20 20 20 20 62 65 |@numrows|.. be|
|00002350| 67 69 6e 0d 0a 20 20 20 | 20 20 20 73 65 6c 65 63 |gin.. | selec|
|00002360| 74 20 40 65 72 72 6e 6f | 20 20 3d 20 33 30 30 30 |t @errno| = 3000|
|00002370| 37 2c 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |7,.. | |
|00002380| 20 40 65 72 72 6d 73 67 | 20 3d 20 27 43 61 6e 6e | @errmsg| = 'Cann|
|00002390| 6f 74 20 55 50 44 41 54 | 45 20 22 25 43 68 69 6c |ot UPDAT|E "%Chil|
|000023a0| 64 22 20 62 65 63 61 75 | 73 65 20 22 25 50 61 72 |d" becau|se "%Par|
|000023b0| 65 6e 74 22 20 64 6f 65 | 73 20 6e 6f 74 20 65 78 |ent" doe|s not ex|
|000023c0| 69 73 74 2e 27 0d 0a 20 | 20 20 20 20 20 67 6f 74 |ist.'.. | got|
|000023d0| 6f 20 65 72 72 6f 72 0d | 0a 20 20 20 20 65 6e 64 |o error.|. end|
|000023e0| 0d 0a 20 20 65 6e 64 0d | 0a 1c 27 00 00 00 00 00 |.. end.|..'.....|
|000023f0| 00 09 00 00 00 01 00 00 | 00 0f 00 00 00 00 00 00 |........|........|
|00002400| 00 00 00 00 00 00 00 02 | 00 00 00 1e 00 00 00 00 |........|........|
|00002410| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002420| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002430| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002440| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 14 00 |........|........|
|00002450| 43 48 49 4c 44 20 55 50 | 44 41 54 45 20 43 41 53 |CHILD UP|DATE CAS|
|00002460| 43 41 44 45 48 02 20 20 | 2f 2a 20 45 52 77 69 6e |CADEH. |/* ERwin|
|00002470| 20 42 75 69 6c 74 69 6e | 20 25 44 61 74 65 74 69 | Builtin| %Dateti|
|00002480| 6d 65 20 2a 2f 0d 0a 20 | 20 2f 2a 20 25 50 61 72 |me */.. | /* %Par|
|00002490| 65 6e 74 20 25 56 65 72 | 62 50 68 72 61 73 65 20 |ent %Ver|bPhrase |
|000024a0| 25 43 68 69 6c 64 20 4f | 4e 20 43 48 49 4c 44 20 |%Child O|N CHILD |
|000024b0| 55 50 44 41 54 45 20 43 | 41 53 43 41 44 45 20 2a |UPDATE C|ASCADE *|
|000024c0| 2f 0d 0a 20 20 69 66 0d | 0a 20 20 20 20 2f 2a 20 |/.. if.|. /* |
|000024d0| 25 25 43 68 69 6c 64 46 | 4b 28 22 20 6f 72 22 2c |%%ChildF|K(" or",|
|000024e0| 75 70 64 61 74 65 29 20 | 2a 2f 0d 0a 20 20 20 20 |update) |*/.. |
|000024f0| 25 43 68 69 6c 64 46 4b | 28 22 20 6f 72 22 2c 75 |%ChildFK|(" or",u|
|00002500| 70 64 61 74 65 29 0d 0a | 20 20 62 65 67 69 6e 0d |pdate)..| begin.|
|00002510| 0a 20 20 20 20 69 6e 73 | 65 72 74 20 25 50 61 72 |. ins|ert %Par|
|00002520| 65 6e 74 20 28 25 50 61 | 72 65 6e 74 50 4b 28 22 |ent (%Pa|rentPK("|
|00002530| 2c 22 2c 29 29 0d 0a 20 | 20 20 20 20 20 73 65 6c |,",)).. | sel|
|00002540| 65 63 74 20 25 43 68 69 | 6c 64 46 4b 28 22 2c 22 |ect %Chi|ldFK(","|
|00002550| 2c 29 0d 0a 20 20 20 20 | 20 20 66 72 6f 6d 20 20 |,).. | from |
|00002560| 20 69 6e 73 65 72 74 65 | 64 0d 0a 20 20 20 20 20 | inserte|d.. |
|00002570| 20 77 68 65 72 65 0d 0a | 20 20 20 20 20 20 20 20 | where..| |
|00002580| 2f 2a 20 25 25 4e 6f 74 | 6e 75 6c 6c 46 4b 28 69 |/* %%Not|nullFK(i|
|00002590| 6e 73 65 72 74 65 64 2c | 22 20 69 73 20 6e 6f 74 |nserted,|" is not|
|000025a0| 20 6e 75 6c 6c 20 61 6e | 64 22 29 20 2a 2f 0d 0a | null an|d") */..|
|000025b0| 20 20 20 20 20 20 20 20 | 25 4e 6f 74 6e 75 6c 6c | |%Notnull|
|000025c0| 46 4b 28 69 6e 73 65 72 | 74 65 64 2c 22 20 69 73 |FK(inser|ted," is|
|000025d0| 20 6e 6f 74 20 6e 75 6c | 6c 20 61 6e 64 22 29 0d | not nul|l and").|
|000025e0| 0a 20 20 20 20 20 20 20 | 20 6e 6f 74 20 65 78 69 |. | not exi|
|000025f0| 73 74 73 20 28 0d 0a 20 | 20 20 20 20 20 20 20 20 |sts (.. | |
|00002600| 20 73 65 6c 65 63 74 20 | 2a 20 66 72 6f 6d 20 25 | select |* from %|
|00002610| 50 61 72 65 6e 74 0d 0a | 20 20 20 20 20 20 20 20 |Parent..| |
|00002620| 20 20 77 68 65 72 65 0d | 0a 20 20 20 20 20 20 20 | where.|. |
|00002630| 20 20 20 20 20 2f 2a 20 | 25 25 4a 6f 69 6e 46 4b | /* |%%JoinFK|
|00002640| 50 4b 28 69 6e 73 65 72 | 74 65 64 2c 25 50 61 72 |PK(inser|ted,%Par|
|00002650| 65 6e 74 2c 22 20 3d 20 | 22 2c 22 20 61 6e 64 22 |ent," = |"," and"|
|00002660| 29 20 2a 2f 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |) */.. | |
|00002670| 20 20 25 4a 6f 69 6e 46 | 4b 50 4b 28 69 6e 73 65 | %JoinF|KPK(inse|
|00002680| 72 74 65 64 2c 25 50 61 | 72 65 6e 74 2c 22 20 3d |rted,%Pa|rent," =|
|00002690| 20 22 2c 22 20 61 6e 64 | 22 29 0d 0a 20 20 20 20 | "," and|").. |
|000026a0| 20 20 20 20 29 0d 0a 20 | 20 65 6e 64 0d 0a 1d 27 | ).. | end...'|
|000026b0| 00 00 00 00 00 00 09 00 | 00 00 01 00 00 00 0f 00 |........|........|
|000026c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 02 00 00 00 |........|........|
|000026d0| 1e 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000026e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000026f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002700| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 05 |........|........|
|00002710| 00 00 00 14 00 43 48 49 | 4c 44 20 55 50 44 41 54 |.....CHI|LD UPDAT|
|00002720| 45 20 53 45 54 4e 55 4c | 4c 6f 02 20 20 2f 2a 20 |E SETNUL|Lo. /* |
|00002730| 45 52 77 69 6e 20 42 75 | 69 6c 74 69 6e 20 25 44 |ERwin Bu|iltin %D|
|00002740| 61 74 65 74 69 6d 65 20 | 2a 2f 0d 0a 20 20 2f 2a |atetime |*/.. /*|
|00002750| 20 25 50 61 72 65 6e 74 | 20 25 56 65 72 62 50 68 | %Parent| %VerbPh|
|00002760| 72 61 73 65 20 25 43 68 | 69 6c 64 20 4f 4e 20 43 |rase %Ch|ild ON C|
|00002770| 48 49 4c 44 20 55 50 44 | 41 54 45 20 53 45 54 20 |HILD UPD|ATE SET |
|00002780| 4e 55 4c 4c 20 2a 2f 0d | 0a 20 20 69 66 0d 0a 20 |NULL */.|. if.. |
|00002790| 20 20 20 2f 2a 20 25 25 | 43 68 69 6c 64 46 4b 28 | /* %%|ChildFK(|
|000027a0| 22 20 6f 72 22 2c 75 70 | 64 61 74 65 29 20 2a 2f |" or",up|date) */|
|000027b0| 0d 0a 20 20 20 20 25 43 | 68 69 6c 64 46 4b 28 22 |.. %C|hildFK("|
|000027c0| 20 6f 72 22 2c 75 70 64 | 61 74 65 29 0d 0a 20 20 | or",upd|ate).. |
|000027d0| 62 65 67 69 6e 0d 0a 20 | 20 20 20 75 70 64 61 74 |begin.. | updat|
|000027e0| 65 20 25 43 68 69 6c 64 | 0d 0a 20 20 20 20 20 20 |e %Child|.. |
|000027f0| 73 65 74 0d 0a 20 20 20 | 20 20 20 20 20 2f 2a 20 |set.. | /* |
|00002800| 25 25 53 65 74 46 4b 28 | 25 43 68 69 6c 64 2c 4e |%%SetFK(|%Child,N|
|00002810| 55 4c 4c 29 20 2a 2f 0d | 0a 20 20 20 20 20 20 20 |ULL) */.|. |
|00002820| 20 25 53 65 74 46 4b 28 | 25 43 68 69 6c 64 2c 4e | %SetFK(|%Child,N|
|00002830| 55 4c 4c 29 0d 0a 20 20 | 20 20 20 20 66 72 6f 6d |ULL).. | from|
|00002840| 20 25 43 68 69 6c 64 2c | 69 6e 73 65 72 74 65 64 | %Child,|inserted|
|00002850| 0d 0a 20 20 20 20 20 20 | 77 68 65 72 65 0d 0a 20 |.. |where.. |
|00002860| 20 20 20 20 20 20 20 2f | 2a 20 25 25 4a 6f 69 6e | /|* %%Join|
|00002870| 50 4b 50 4b 28 25 43 68 | 69 6c 64 2c 69 6e 73 65 |PKPK(%Ch|ild,inse|
|00002880| 72 74 65 64 2c 22 20 3d | 20 22 2c 22 20 61 6e 64 |rted," =| "," and|
|00002890| 22 29 20 2a 2f 0d 0a 20 | 20 20 20 20 20 20 20 25 |") */.. | %|
|000028a0| 4a 6f 69 6e 50 4b 50 4b | 28 25 43 68 69 6c 64 2c |JoinPKPK|(%Child,|
|000028b0| 69 6e 73 65 72 74 65 64 | 2c 22 20 3d 20 22 2c 22 |inserted|," = ","|
|000028c0| 20 61 6e 64 22 29 20 61 | 6e 64 20 0d 0a 20 20 20 | and") a|nd .. |
|000028d0| 20 20 20 20 20 6e 6f 74 | 20 65 78 69 73 74 73 20 | not| exists |
|000028e0| 28 0d 0a 20 20 20 20 20 | 20 20 20 20 20 73 65 6c |(.. | sel|
|000028f0| 65 63 74 20 2a 20 66 72 | 6f 6d 20 25 50 61 72 65 |ect * fr|om %Pare|
|00002900| 6e 74 0d 0a 20 20 20 20 | 20 20 20 20 20 20 77 68 |nt.. | wh|
|00002910| 65 72 65 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |ere.. | |
|00002920| 20 2f 2a 20 25 25 4a 6f | 69 6e 46 4b 50 4b 28 69 | /* %%Jo|inFKPK(i|
|00002930| 6e 73 65 72 74 65 64 2c | 25 50 61 72 65 6e 74 2c |nserted,|%Parent,|
|00002940| 22 20 3d 20 22 2c 22 20 | 61 6e 64 22 29 20 2a 2f |" = "," |and") */|
|00002950| 0d 0a 20 20 20 20 20 20 | 20 20 20 20 20 20 25 4a |.. | %J|
|00002960| 6f 69 6e 46 4b 50 4b 28 | 69 6e 73 65 72 74 65 64 |oinFKPK(|inserted|
|00002970| 2c 25 50 61 72 65 6e 74 | 2c 22 20 3d 20 22 2c 22 |,%Parent|," = ","|
|00002980| 20 61 6e 64 22 29 0d 0a | 20 20 20 20 20 20 20 20 | and")..| |
|00002990| 29 0d 0a 20 20 65 6e 64 | 0d 0a 1e 27 00 00 00 00 |).. end|...'....|
|000029a0| 00 00 09 00 00 00 01 00 | 00 00 0f 00 00 00 00 00 |........|........|
|000029b0| 00 00 00 00 00 00 00 00 | 02 00 00 00 1e 00 00 00 |........|........|
|000029c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000029d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000029e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000029f0| 00 00 00 00 00 00 00 00 | 00 00 00 05 00 00 00 15 |........|........|
|00002a00| 00 43 48 49 4c 44 20 44 | 45 4c 45 54 45 20 52 45 |.CHILD D|ELETE RE|
|00002a10| 53 54 52 49 43 54 67 02 | 20 20 20 20 2f 2a 20 45 |STRICTg.| /* E|
|00002a20| 52 77 69 6e 20 42 75 69 | 6c 74 69 6e 20 25 44 61 |Rwin Bui|ltin %Da|
|00002a30| 74 65 74 69 6d 65 20 2a | 2f 0d 0a 20 20 20 20 2f |tetime *|/.. /|
|00002a40| 2a 20 25 50 61 72 65 6e | 74 20 25 56 65 72 62 50 |* %Paren|t %VerbP|
|00002a50| 68 72 61 73 65 20 25 43 | 68 69 6c 64 20 4f 4e 20 |hrase %C|hild ON |
|00002a60| 43 48 49 4c 44 20 44 45 | 4c 45 54 45 20 52 45 53 |CHILD DE|LETE RES|
|00002a70| 54 52 49 43 54 20 2a 2f | 0d 0a 20 20 20 20 69 66 |TRICT */|.. if|
|00002a80| 20 65 78 69 73 74 73 20 | 28 73 65 6c 65 63 74 20 | exists |(select |
|00002a90| 2a 20 66 72 6f 6d 20 64 | 65 6c 65 74 65 64 2c 25 |* from d|eleted,%|
|00002aa0| 50 61 72 65 6e 74 0d 0a | 20 20 20 20 20 20 77 68 |Parent..| wh|
|00002ab0| 65 72 65 0d 0a 20 20 20 | 20 20 20 20 20 2f 2a 20 |ere.. | /* |
|00002ac0| 25 25 4a 6f 69 6e 46 4b | 50 4b 28 64 65 6c 65 74 |%%JoinFK|PK(delet|
|00002ad0| 65 64 2c 25 50 61 72 65 | 6e 74 2c 22 20 3d 20 22 |ed,%Pare|nt," = "|
|00002ae0| 2c 22 20 61 6e 64 22 29 | 20 2a 2f 0d 0a 20 20 20 |," and")| */.. |
|00002af0| 20 20 20 20 20 25 4a 6f | 69 6e 46 4b 50 4b 28 64 | %Jo|inFKPK(d|
|00002b00| 65 6c 65 74 65 64 2c 25 | 50 61 72 65 6e 74 2c 22 |eleted,%|Parent,"|
|00002b10| 20 3d 20 22 2c 22 20 61 | 6e 64 22 29 20 61 6e 64 | = "," a|nd") and|
|00002b20| 0d 0a 20 20 20 20 20 20 | 20 20 6e 6f 74 20 65 78 |.. | not ex|
|00002b30| 69 73 74 73 20 28 0d 0a | 20 20 20 20 20 20 20 20 |ists (..| |
|00002b40| 20 20 73 65 6c 65 63 74 | 20 2a 20 66 72 6f 6d 20 | select| * from |
|00002b50| 25 43 68 69 6c 64 0d 0a | 20 20 20 20 20 20 20 20 |%Child..| |
|00002b60| 20 20 77 68 65 72 65 0d | 0a 20 20 20 20 20 20 20 | where.|. |
|00002b70| 20 20 20 20 20 2f 2a 20 | 25 25 4a 6f 69 6e 46 4b | /* |%%JoinFK|
|00002b80| 50 4b 28 25 43 68 69 6c | 64 2c 25 50 61 72 65 6e |PK(%Chil|d,%Paren|
|00002b90| 74 2c 22 20 3d 20 22 2c | 22 20 61 6e 64 22 29 20 |t," = ",|" and") |
|00002ba0| 2a 2f 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |*/.. | |
|00002bb0| 25 4a 6f 69 6e 46 4b 50 | 4b 28 25 43 68 69 6c 64 |%JoinFKP|K(%Child|
|00002bc0| 2c 25 50 61 72 65 6e 74 | 2c 22 20 3d 20 22 2c 22 |,%Parent|," = ","|
|00002bd0| 20 61 6e 64 22 29 0d 0a | 20 20 20 20 20 20 20 20 | and")..| |
|00002be0| 29 0d 0a 20 20 20 20 29 | 0d 0a 20 20 20 20 62 65 |).. )|.. be|
|00002bf0| 67 69 6e 0d 0a 20 20 20 | 20 20 20 73 65 6c 65 63 |gin.. | selec|
|00002c00| 74 20 40 65 72 72 6e 6f | 20 20 3d 20 33 30 30 31 |t @errno| = 3001|
|00002c10| 30 2c 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 20 |0,.. | |
|00002c20| 20 40 65 72 72 6d 73 67 | 20 3d 20 27 43 61 6e 6e | @errmsg| = 'Cann|
|00002c30| 6f 74 20 44 45 4c 45 54 | 45 20 6c 61 73 74 20 22 |ot DELET|E last "|
|00002c40| 25 43 68 69 6c 64 22 20 | 62 65 63 61 75 73 65 20 |%Child" |because |
|00002c50| 22 25 50 61 72 65 6e 74 | 22 20 65 78 69 73 74 73 |"%Parent|" exists|
|00002c60| 2e 27 0d 0a 20 20 20 20 | 20 20 67 6f 74 6f 20 65 |.'.. | goto e|
|00002c70| 72 72 6f 72 0d 0a 20 20 | 20 20 65 6e 64 0d 0a 20 |rror.. | end.. |
|00002c80| 27 00 00 00 00 00 00 09 | 00 00 00 01 00 00 00 0f |'.......|........|
|00002c90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 02 00 00 |........|........|
|00002ca0| 00 1e 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002cb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002cc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002cd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ce0| 05 00 00 00 14 00 43 48 | 49 4c 44 20 44 45 4c 45 |......CH|ILD DELE|
|00002cf0| 54 45 20 43 41 53 43 41 | 44 45 cc 01 20 20 20 20 |TE CASCA|DE.. |
|00002d00| 2f 2a 20 45 52 77 69 6e | 20 42 75 69 6c 74 69 6e |/* ERwin| Builtin|
|00002d10| 20 25 44 61 74 65 74 69 | 6d 65 20 2a 2f 0d 0a 20 | %Dateti|me */.. |
|00002d20| 20 20 20 2f 2a 20 25 50 | 61 72 65 6e 74 20 25 56 | /* %P|arent %V|
|00002d30| 65 72 62 50 68 72 61 73 | 65 20 25 43 68 69 6c 64 |erbPhras|e %Child|
|00002d40| 20 4f 4e 20 43 48 49 4c | 44 20 44 45 4c 45 54 45 | ON CHIL|D DELETE|
|00002d50| 20 43 41 53 43 41 44 45 | 20 2a 2f 0d 0a 20 20 20 | CASCADE| */.. |
|00002d60| 20 64 65 6c 65 74 65 20 | 25 50 61 72 65 6e 74 0d | delete |%Parent.|
|00002d70| 0a 20 20 20 20 20 20 66 | 72 6f 6d 20 25 50 61 72 |. f|rom %Par|
|00002d80| 65 6e 74 2c 64 65 6c 65 | 74 65 64 0d 0a 20 20 20 |ent,dele|ted.. |
|00002d90| 20 20 20 77 68 65 72 65 | 0d 0a 20 20 20 20 20 20 | where|.. |
|00002da0| 20 20 2f 2a 20 25 25 4a | 6f 69 6e 46 4b 50 4b 28 | /* %%J|oinFKPK(|
|00002db0| 64 65 6c 65 74 65 64 2c | 25 50 61 72 65 6e 74 2c |deleted,|%Parent,|
|00002dc0| 22 20 3d 20 22 2c 22 20 | 61 6e 64 22 29 20 2a 2f |" = "," |and") */|
|00002dd0| 0d 0a 20 20 20 20 20 20 | 20 20 25 4a 6f 69 6e 46 |.. | %JoinF|
|00002de0| 4b 50 4b 28 64 65 6c 65 | 74 65 64 2c 25 50 61 72 |KPK(dele|ted,%Par|
|00002df0| 65 6e 74 2c 22 20 3d 20 | 22 2c 22 20 61 6e 64 22 |ent," = |"," and"|
|00002e00| 29 20 61 6e 64 0d 0a 20 | 20 20 20 20 20 20 20 6e |) and.. | n|
|00002e10| 6f 74 20 65 78 69 73 74 | 73 20 28 0d 0a 20 20 20 |ot exist|s (.. |
|00002e20| 20 20 20 20 20 20 20 73 | 65 6c 65 63 74 20 2a 20 | s|elect * |
|00002e30| 66 72 6f 6d 20 25 43 68 | 69 6c 64 0d 0a 20 20 20 |from %Ch|ild.. |
|00002e40| 20 20 20 20 20 20 20 77 | 68 65 72 65 0d 0a 20 20 | w|here.. |
|00002e50| 20 20 20 20 20 20 20 20 | 20 20 2f 2a 20 25 25 4a | | /* %%J|
|00002e60| 6f 69 6e 46 4b 50 4b 28 | 25 43 68 69 6c 64 2c 25 |oinFKPK(|%Child,%|
|00002e70| 50 61 72 65 6e 74 2c 22 | 20 3d 20 22 2c 22 20 61 |Parent,"| = "," a|
|00002e80| 6e 64 22 29 20 2a 2f 0d | 0a 20 20 20 20 20 20 20 |nd") */.|. |
|00002e90| 20 20 20 20 20 25 4a 6f | 69 6e 46 4b 50 4b 28 25 | %Jo|inFKPK(%|
|00002ea0| 43 68 69 6c 64 2c 25 50 | 61 72 65 6e 74 2c 22 20 |Child,%P|arent," |
|00002eb0| 3d 20 22 2c 22 20 61 6e | 64 22 29 0d 0a 20 20 20 |= "," an|d").. |
|00002ec0| 20 20 20 20 20 29 0d 0a | 21 27 00 00 00 00 00 00 | )..|!'......|
|00002ed0| 09 00 00 00 01 00 00 00 | 0f 00 00 00 00 00 00 00 |........|........|
|00002ee0| 00 00 00 00 00 00 02 00 | 00 00 1e 00 00 00 00 00 |........|........|
|00002ef0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002f20| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 16 00 50 |........|.......P|
|00002f30| 41 52 45 4e 54 20 49 4e | 53 45 52 54 20 52 45 53 |ARENT IN|SERT RES|
|00002f40| 54 52 49 43 54 e8 01 20 | 20 20 20 2f 2a 20 45 52 |TRICT.. | /* ER|
|00002f50| 77 69 6e 20 42 75 69 6c | 74 69 6e 20 25 44 61 74 |win Buil|tin %Dat|
|00002f60| 65 74 69 6d 65 20 2a 2f | 0d 0a 20 20 20 20 2f 2a |etime */|.. /*|
|00002f70| 20 25 50 61 72 65 6e 74 | 20 25 56 65 72 62 50 68 | %Parent| %VerbPh|
|00002f80| 72 61 73 65 20 25 43 68 | 69 6c 64 20 4f 4e 20 50 |rase %Ch|ild ON P|
|00002f90| 41 52 45 4e 54 20 49 4e | 53 45 52 54 20 52 45 53 |ARENT IN|SERT RES|
|00002fa0| 54 52 49 43 54 20 2a 2f | 0d 0a 20 20 20 20 69 66 |TRICT */|.. if|
|00002fb0| 20 65 78 69 73 74 73 20 | 28 73 65 6c 65 63 74 20 | exists |(select |
|00002fc0| 2a 20 66 72 6f 6d 20 69 | 6e 73 65 72 74 65 64 0d |* from i|nserted.|
|00002fd0| 0a 20 20 20 20 20 20 77 | 68 65 72 65 20 6e 6f 74 |. w|here not|
|00002fe0| 20 65 78 69 73 74 73 20 | 28 0d 0a 20 20 20 20 20 | exists |(.. |
|00002ff0| 20 20 20 20 20 73 65 6c | 65 63 74 20 2a 20 66 72 | sel|ect * fr|
|00003000| 6f 6d 20 25 43 68 69 6c | 64 0d 0a 20 20 20 20 20 |om %Chil|d.. |
|00003010| 20 20 20 20 20 77 68 65 | 72 65 0d 0a 20 20 20 20 | whe|re.. |
|00003020| 20 20 20 20 20 20 20 20 | 2f 2a 20 25 25 4a 6f 69 | |/* %%Joi|
|00003030| 6e 46 4b 50 4b 28 25 43 | 68 69 6c 64 2c 69 6e 73 |nFKPK(%C|hild,ins|
|00003040| 65 72 74 65 64 2c 22 20 | 3d 20 22 2c 22 20 61 6e |erted," |= "," an|
|00003050| 64 22 29 20 2a 2f 0d 0a | 20 20 20 20 20 20 20 20 |d") */..| |
|00003060| 20 20 20 20 25 4a 6f 69 | 6e 46 4b 50 4b 28 25 43 | %Joi|nFKPK(%C|
|00003070| 68 69 6c 64 2c 69 6e 73 | 65 72 74 65 64 2c 22 20 |hild,ins|erted," |
|00003080| 3d 20 22 2c 22 20 61 6e | 64 22 29 0d 0a 20 20 20 |= "," an|d").. |
|00003090| 20 20 20 29 0d 0a 20 20 | 20 20 29 0d 0a 20 20 20 | ).. | ).. |
|000030a0| 20 62 65 67 69 6e 0d 0a | 20 20 20 20 20 20 73 65 | begin..| se|
|000030b0| 6c 65 63 74 20 40 65 72 | 72 6e 6f 20 20 3d 20 33 |lect @er|rno = 3|
|000030c0| 30 30 31 31 2c 0d 0a 20 | 20 20 20 20 20 20 20 20 |0011,.. | |
|000030d0| 20 20 20 20 40 65 72 72 | 6d 73 67 20 3d 20 27 43 | @err|msg = 'C|
|000030e0| 61 6e 6e 6f 74 20 49 4e | 53 45 52 54 20 22 25 50 |annot IN|SERT "%P|
|000030f0| 61 72 65 6e 74 22 20 62 | 65 63 61 75 73 65 20 22 |arent" b|ecause "|
|00003100| 25 43 68 69 6c 64 22 20 | 64 6f 65 73 20 6e 6f 74 |%Child" |does not|
|00003110| 2e 27 0d 0a 20 20 20 20 | 20 20 67 6f 74 6f 20 65 |.'.. | goto e|
|00003120| 72 72 6f 72 0d 0a 20 20 | 20 20 65 6e 64 0d 0a 24 |rror.. | end..$|
|00003130| 27 00 00 00 00 00 00 09 | 00 00 00 01 00 00 00 0f |'.......|........|
|00003140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 02 00 00 |........|........|
|00003150| 00 1e 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003190| 05 00 00 00 0d 00 55 50 | 44 41 54 45 20 48 45 41 |......UP|DATE HEA|
|000031a0| 44 45 52 aa 01 63 72 65 | 61 74 65 20 74 72 69 67 |DER..cre|ate trig|
|000031b0| 67 65 72 20 74 25 31 41 | 63 74 69 6f 6e 5f 25 32 |ger t%1A|ction_%2|
|000031c0| 37 54 61 62 6c 65 4e 61 | 6d 65 20 6f 6e 20 25 54 |7TableNa|me on %T|
|000031d0| 61 62 6c 65 4e 61 6d 65 | 20 66 6f 72 20 25 41 63 |ableName| for %Ac|
|000031e0| 74 69 6f 6e 20 61 73 0d | 0a 2f 2a 20 45 52 77 69 |tion as.|./* ERwi|
|000031f0| 6e 20 42 75 69 6c 74 69 | 6e 20 25 44 61 74 65 74 |n Builti|n %Datet|
|00003200| 69 6d 65 20 2a 2f 0d 0a | 2f 2a 20 25 41 63 74 69 |ime */..|/* %Acti|
|00003210| 6f 6e 20 74 72 69 67 67 | 65 72 20 6f 6e 20 25 54 |on trigg|er on %T|
|00003220| 61 62 6c 65 4e 61 6d 65 | 20 2a 2f 0d 0a 62 65 67 |ableName| */..beg|
|00003230| 69 6e 0d 0a 20 20 64 65 | 63 6c 61 72 65 20 20 40 |in.. de|clare @|
|00003240| 6e 75 6d 72 6f 77 73 20 | 69 6e 74 2c 0d 0a 20 20 |numrows |int,.. |
|00003250| 20 20 20 20 20 20 20 20 | 20 40 6e 75 6c 6c 63 6e | | @nullcn|
|00003260| 74 20 69 6e 74 2c 0d 0a | 20 20 20 20 20 20 20 20 |t int,..| |
|00003270| 20 20 20 40 76 61 6c 69 | 64 63 6e 74 20 69 6e 74 | @vali|dcnt int|
|00003280| 2c 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 25 50 |,.. | %P|
|00003290| 4b 44 65 63 6c 28 2c 40 | 69 6e 73 29 25 64 65 63 |KDecl(,@|ins)%dec|
|000032a0| 6c 28 62 43 6f 6d 6d 61 | 2c 30 29 25 46 6f 72 45 |l(bComma|,0)%ForE|
|000032b0| 61 63 68 41 74 74 28 29 | 20 7b 25 69 66 28 25 41 |achAtt()| {%if(%A|
|000032c0| 74 74 49 73 50 6b 29 20 | 7b 25 3d 28 62 43 6f 6d |ttIsPk) |{%=(bCom|
|000032d0| 6d 61 2c 31 29 7d 20 7d | 25 69 66 20 28 25 3d 3d |ma,1)} }|%if (%==|
|000032e0| 28 25 3a 62 43 6f 6d 6d | 61 2c 31 29 29 20 7b 2c |(%:bComm|a,1)) {,|
|000032f0| 7d 0d 0a 20 20 20 20 20 | 20 20 20 20 20 20 40 65 |}.. | @e|
|00003300| 72 72 6e 6f 20 20 20 69 | 6e 74 2c 0d 0a 20 20 20 |rrno i|nt,.. |
|00003310| 20 20 20 20 20 20 20 20 | 40 65 72 72 6d 73 67 20 | |@errmsg |
|00003320| 20 76 61 72 63 68 61 72 | 28 32 35 35 29 0d 0a 0d | varchar|(255)...|
|00003330| 0a 20 20 73 65 6c 65 63 | 74 20 40 6e 75 6d 72 6f |. selec|t @numro|
|00003340| 77 73 20 3d 20 40 40 72 | 6f 77 63 6f 75 6e 74 28 |ws = @@r|owcount(|
|00003350| 27 00 00 00 00 00 00 09 | 00 00 00 01 00 00 00 0f |'.......|........|
|00003360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 02 00 00 |........|........|
|00003370| 00 1e 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000033a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000033b0| 05 00 00 00 0d 00 55 50 | 44 41 54 45 20 46 4f 4f |......UP|DATE FOO|
|000033c0| 54 45 52 74 00 20 20 2f | 2a 20 45 52 77 69 6e 20 |TERt. /|* ERwin |
|000033d0| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|000033e0| 65 20 2a 2f 0d 0a 20 20 | 72 65 74 75 72 6e 0d 0a |e */.. |return..|
|000033f0| 65 72 72 6f 72 3a 0d 0a | 20 20 20 20 72 61 69 73 |error:..| rais|
|00003400| 65 72 72 6f 72 20 40 65 | 72 72 6e 6f 20 40 65 72 |error @e|rrno @er|
|00003410| 72 6d 73 67 0d 0a 20 20 | 20 20 72 6f 6c 6c 62 61 |rmsg.. | rollba|
|00003420| 63 6b 20 74 72 61 6e 73 | 61 63 74 69 6f 6e 0d 0a |ck trans|action..|
|00003430| 65 6e 64 0d 0a 67 6f 0d | 0a 29 27 00 00 00 00 00 |end..go.|.)'.....|
|00003440| 00 09 00 00 00 01 00 00 | 00 0f 00 00 00 00 00 00 |........|........|
|00003450| 00 00 00 00 00 00 00 02 | 00 00 00 1e 00 00 00 00 |........|........|
|00003460| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003470| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003480| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003490| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 0d 00 |........|........|
|000034a0| 44 45 4c 45 54 45 20 48 | 45 41 44 45 52 c9 00 63 |DELETE H|EADER..c|
|000034b0| 72 65 61 74 65 20 74 72 | 69 67 67 65 72 20 74 25 |reate tr|igger t%|
|000034c0| 31 41 63 74 69 6f 6e 5f | 25 32 37 54 61 62 6c 65 |1Action_|%27Table|
|000034d0| 4e 61 6d 65 20 6f 6e 20 | 25 54 61 62 6c 65 4e 61 |Name on |%TableNa|
|000034e0| 6d 65 20 66 6f 72 20 25 | 41 63 74 69 6f 6e 20 61 |me for %|Action a|
|000034f0| 73 0d 0a 2f 2a 20 45 52 | 77 69 6e 20 42 75 69 6c |s../* ER|win Buil|
|00003500| 74 69 6e 20 25 44 61 74 | 65 74 69 6d 65 20 2a 2f |tin %Dat|etime */|
|00003510| 0d 0a 2f 2a 20 25 41 63 | 74 69 6f 6e 20 74 72 69 |../* %Ac|tion tri|
|00003520| 67 67 65 72 20 6f 6e 20 | 25 54 61 62 6c 65 4e 61 |gger on |%TableNa|
|00003530| 6d 65 20 2a 2f 0d 0a 62 | 65 67 69 6e 0d 0a 20 20 |me */..b|egin.. |
|00003540| 64 65 63 6c 61 72 65 20 | 20 40 65 72 72 6e 6f 20 |declare | @errno |
|00003550| 20 20 69 6e 74 2c 0d 0a | 20 20 20 20 20 20 20 20 | int,..| |
|00003560| 20 20 20 40 65 72 72 6d | 73 67 20 20 76 61 72 63 | @errm|sg varc|
|00003570| 68 61 72 28 32 35 35 29 | 2a 27 00 00 00 00 00 00 |har(255)|*'......|
|00003580| 09 00 00 00 01 00 00 00 | 0f 00 00 00 00 00 00 00 |........|........|
|00003590| 00 00 00 00 00 00 02 00 | 00 00 1e 00 00 00 00 00 |........|........|
|000035a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000035d0| 00 00 00 00 00 00 00 00 | 00 05 00 00 00 0d 00 44 |........|.......D|
|000035e0| 45 4c 45 54 45 20 46 4f | 4f 54 45 52 78 00 20 20 |ELETE FO|OTERx. |
|000035f0| 20 20 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 | /* ERw|in Built|
|00003600| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|00003610| 0a 20 20 20 20 72 65 74 | 75 72 6e 0d 0a 65 72 72 |. ret|urn..err|
|00003620| 6f 72 3a 0d 0a 20 20 20 | 20 72 61 69 73 65 72 72 |or:.. | raiserr|
|00003630| 6f 72 20 40 65 72 72 6e | 6f 20 40 65 72 72 6d 73 |or @errn|o @errms|
|00003640| 67 0d 0a 20 20 20 20 72 | 6f 6c 6c 62 61 63 6b 20 |g.. r|ollback |
|00003650| 74 72 61 6e 73 61 63 74 | 69 6f 6e 0d 0a 65 6e 64 |transact|ion..end|
|00003660| 0d 0a 67 6f 0d 0a 2b 27 | 00 00 00 00 00 00 09 00 |..go..+'|........|
|00003670| 00 00 01 00 00 00 0f 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003680| 00 00 00 00 02 00 00 00 | 1e 00 00 00 00 00 00 00 |........|........|
|00003690| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000036a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000036b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000036c0| 00 00 00 00 00 00 00 05 | 00 00 00 0d 00 49 4e 53 |........|.....INS|
|000036d0| 45 52 54 20 48 45 41 44 | 45 52 3a 01 63 72 65 61 |ERT HEAD|ER:.crea|
|000036e0| 74 65 20 74 72 69 67 67 | 65 72 20 74 25 31 41 63 |te trigg|er t%1Ac|
|000036f0| 74 69 6f 6e 5f 25 32 37 | 54 61 62 6c 65 4e 61 6d |tion_%27|TableNam|
|00003700| 65 20 6f 6e 20 25 54 61 | 62 6c 65 4e 61 6d 65 20 |e on %Ta|bleName |
|00003710| 66 6f 72 20 25 41 63 74 | 69 6f 6e 20 61 73 0d 0a |for %Act|ion as..|
|00003720| 2f 2a 20 45 52 77 69 6e | 20 42 75 69 6c 74 69 6e |/* ERwin| Builtin|
|00003730| 20 25 44 61 74 65 74 69 | 6d 65 20 2a 2f 0d 0a 2f | %Dateti|me */../|
|00003740| 2a 20 25 41 63 74 69 6f | 6e 20 74 72 69 67 67 65 |* %Actio|n trigge|
|00003750| 72 20 6f 6e 20 25 54 61 | 62 6c 65 4e 61 6d 65 20 |r on %Ta|bleName |
|00003760| 2a 2f 0d 0a 62 65 67 69 | 6e 0d 0a 20 20 64 65 63 |*/..begi|n.. dec|
|00003770| 6c 61 72 65 20 20 40 6e | 75 6d 72 6f 77 73 20 69 |lare @n|umrows i|
|00003780| 6e 74 2c 0d 0a 20 20 20 | 20 20 20 20 20 20 20 20 |nt,.. | |
|00003790| 40 6e 75 6c 6c 63 6e 74 | 20 69 6e 74 2c 0d 0a 20 |@nullcnt| int,.. |
|000037a0| 20 20 20 20 20 20 20 20 | 20 20 40 76 61 6c 69 64 | | @valid|
|000037b0| 63 6e 74 20 69 6e 74 2c | 0d 0a 20 20 20 20 20 20 |cnt int,|.. |
|000037c0| 20 20 20 20 20 40 65 72 | 72 6e 6f 20 20 20 69 6e | @er|rno in|
|000037d0| 74 2c 0d 0a 20 20 20 20 | 20 20 20 20 20 20 20 40 |t,.. | @|
|000037e0| 65 72 72 6d 73 67 20 20 | 76 61 72 63 68 61 72 28 |errmsg |varchar(|
|000037f0| 32 35 35 29 0d 0a 0d 0a | 20 20 73 65 6c 65 63 74 |255)....| select|
|00003800| 20 40 6e 75 6d 72 6f 77 | 73 20 3d 20 40 40 72 6f | @numrow|s = @@ro|
|00003810| 77 63 6f 75 6e 74 2c 27 | 00 00 00 00 00 00 09 00 |wcount,'|........|
|00003820| 00 00 01 00 00 00 0f 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003830| 00 00 00 00 02 00 00 00 | 1e 00 00 00 00 00 00 00 |........|........|
|00003840| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003850| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003860| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003870| 00 00 00 00 00 00 00 05 | 00 00 00 0d 00 49 4e 53 |........|.....INS|
|00003880| 45 52 54 20 46 4f 4f 54 | 45 52 74 00 20 20 2f 2a |ERT FOOT|ERt. /*|
|00003890| 20 45 52 77 69 6e 20 42 | 75 69 6c 74 69 6e 20 25 | ERwin B|uiltin %|
|000038a0| 44 61 74 65 74 69 6d 65 | 20 2a 2f 0d 0a 20 20 72 |Datetime| */.. r|
|000038b0| 65 74 75 72 6e 0d 0a 65 | 72 72 6f 72 3a 0d 0a 20 |eturn..e|rror:.. |
|000038c0| 20 20 20 72 61 69 73 65 | 72 72 6f 72 20 40 65 72 | raise|rror @er|
|000038d0| 72 6e 6f 20 40 65 72 72 | 6d 73 67 0d 0a 20 20 20 |rno @err|msg.. |
|000038e0| 20 72 6f 6c 6c 62 61 63 | 6b 20 74 72 61 6e 73 61 | rollbac|k transa|
|000038f0| 63 74 69 6f 6e 0d 0a 65 | 6e 64 0d 0a 67 6f 0d 0a |ction..e|nd..go..|
|00003900| 2d 27 00 00 00 00 00 00 | 09 00 00 00 01 00 00 00 |-'......|........|
|00003910| 0f 00 00 00 00 00 00 00 | 00 00 00 00 00 00 02 00 |........|........|
|00003920| 00 00 1e 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003930| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003940| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003950| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003960| 00 05 00 00 00 15 00 43 | 55 53 54 4f 4d 20 54 52 |.......C|USTOM TR|
|00003970| 49 47 47 45 52 20 48 45 | 41 44 45 52 46 00 63 72 |IGGER HE|ADERF.cr|
|00003980| 65 61 74 65 20 74 72 69 | 67 67 65 72 20 25 54 72 |eate tri|gger %Tr|
|00003990| 69 67 67 65 72 4e 61 6d | 65 20 6f 6e 20 25 54 61 |iggerNam|e on %Ta|
|000039a0| 62 6c 65 4e 61 6d 65 0d | 0a 20 20 66 6f 72 20 25 |bleName.|. for %|
|000039b0| 41 63 74 69 6f 6e 73 28 | 22 2c 22 29 0d 0a 20 20 |Actions(|",").. |
|000039c0| 61 73 0d 0a 2e 27 00 00 | 00 00 00 00 09 00 00 00 |as...'..|........|
|000039d0| 01 00 00 00 0f 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000039e0| 00 00 02 00 00 00 1e 00 | 00 00 00 00 00 00 00 00 |........|........|
|000039f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a20| 00 00 00 00 00 05 00 00 | 00 15 00 43 55 53 54 4f |........|...CUSTO|
|00003a30| 4d 20 54 52 49 47 47 45 | 52 20 46 4f 4f 54 45 52 |M TRIGGE|R FOOTER|
|00003a40| 00 00 00 00 00 00 00 00 | 00 00 09 00 00 00 01 00 |........|........|
|00003a50| 00 00 0f 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a60| 02 00 00 00 1e 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003aa0| 00 00 00 05 00 00 00 15 | 00 43 55 53 54 4f 4d 20 |........|.CUSTOM |
|00003ab0| 54 52 49 47 47 45 52 20 | 46 4f 4f 54 45 52 00 00 |TRIGGER |FOOTER..|
|00003ac0| 00 00 00 00 00 00 00 00 | 09 00 00 00 01 00 00 00 |........|........|
|00003ad0| 0f 00 00 00 00 00 00 00 | 00 00 00 00 00 00 02 00 |........|........|
|00003ae0| 00 00 1e 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b20| 00 05 00 00 00 15 00 43 | 55 53 54 4f 4d 20 54 52 |.......C|USTOM TR|
|00003b30| 49 47 47 45 52 20 46 4f | 4f 54 45 52 04 00 67 6f |IGGER FO|OTER..go|
|00003b40| 0d 0a 2f 27 00 00 00 00 | 00 00 09 00 00 00 01 00 |../'....|........|
|00003b50| 00 00 0f 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b60| 02 00 00 00 1e 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ba0| 00 00 00 05 00 00 00 1b | 00 43 55 53 54 4f 4d 20 |........|.CUSTOM |
|00003bb0| 54 52 49 47 47 45 52 20 | 44 45 46 41 55 4c 54 20 |TRIGGER |DEFAULT |
|00003bc0| 42 4f 44 59 7f 02 63 72 | 65 61 74 65 20 74 72 69 |BODY..cr|eate tri|
|00003bd0| 67 67 65 72 20 25 54 72 | 69 67 67 65 72 4e 61 6d |gger %Tr|iggerNam|
|00003be0| 65 20 6f 6e 20 25 54 61 | 62 6c 65 4e 61 6d 65 0d |e on %Ta|bleName.|
|00003bf0| 0a 20 20 66 6f 72 20 25 | 41 63 74 69 6f 6e 73 28 |. for %|Actions(|
|00003c00| 22 2c 22 29 0d 0a 20 20 | 61 73 0d 0a 2f 2a 20 45 |",").. |as../* E|
|00003c10| 52 77 69 6e 20 42 75 69 | 6c 74 69 6e 20 25 44 61 |Rwin Bui|ltin %Da|
|00003c20| 74 65 74 69 6d 65 20 2a | 2f 0d 0a 2f 2a 20 25 41 |tetime *|/../* %A|
|00003c30| 63 74 69 6f 6e 73 28 22 | 2c 22 29 20 74 72 69 67 |ctions("|,") trig|
|00003c40| 67 65 72 20 6f 6e 20 25 | 54 61 62 6c 65 4e 61 6d |ger on %|TableNam|
|00003c50| 65 20 2a 2f 0d 0a 2f 2a | 20 64 65 66 61 75 6c 74 |e */../*| default|
|00003c60| 20 62 6f 64 79 20 66 6f | 72 20 25 54 72 69 67 67 | body fo|r %Trigg|
|00003c70| 65 72 4e 61 6d 65 20 2a | 2f 0d 0a 62 65 67 69 6e |erName *|/..begin|
|00003c80| 0d 0a 20 20 64 65 63 6c | 61 72 65 20 20 40 6e 75 |.. decl|are @nu|
|00003c90| 6d 72 6f 77 73 20 69 6e | 74 2c 0d 0a 20 20 20 20 |mrows in|t,.. |
|00003ca0| 20 20 20 20 20 20 20 40 | 6e 75 6c 6c 63 6e 74 20 | @|nullcnt |
|00003cb0| 69 6e 74 2c 0d 0a 20 20 | 20 20 20 20 20 20 20 20 |int,.. | |
|00003cc0| 20 40 76 61 6c 69 64 63 | 6e 74 20 69 6e 74 2c 0d | @validc|nt int,.|
|00003cd0| 0a 20 20 20 20 20 20 20 | 20 20 20 20 25 50 4b 44 |. | %PKD|
|00003ce0| 65 63 6c 28 2c 40 69 6e | 73 29 25 64 65 63 6c 28 |ecl(,@in|s)%decl(|
|00003cf0| 62 43 6f 6d 6d 61 2c 30 | 29 25 46 6f 72 45 61 63 |bComma,0|)%ForEac|
|00003d00| 68 41 74 74 28 29 20 7b | 25 69 66 28 25 41 74 74 |hAtt() {|%if(%Att|
|00003d10| 49 73 50 6b 29 20 7b 25 | 3d 28 62 43 6f 6d 6d 61 |IsPk) {%|=(bComma|
|00003d20| 2c 31 29 7d 20 7d 25 69 | 66 20 28 25 3d 3d 28 25 |,1)} }%i|f (%==(%|
|00003d30| 3a 62 43 6f 6d 6d 61 2c | 31 29 29 20 7b 2c 7d 0d |:bComma,|1)) {,}.|
|00003d40| 0a 20 20 20 20 20 20 20 | 20 20 20 20 40 65 72 72 |. | @err|
|00003d50| 6e 6f 20 20 20 69 6e 74 | 2c 0d 0a 20 20 20 20 20 |no int|,.. |
|00003d60| 20 20 20 20 20 20 40 65 | 72 72 6d 73 67 20 20 76 | @e|rrmsg v|
|00003d70| 61 72 63 68 61 72 28 32 | 35 35 29 0d 0a 0d 0a 20 |archar(2|55).... |
|00003d80| 20 73 65 6c 65 63 74 20 | 40 6e 75 6d 72 6f 77 73 | select |@numrows|
|00003d90| 20 3d 20 40 40 72 6f 77 | 63 6f 75 6e 74 0d 0a 25 | = @@row|count..%|
|00003da0| 46 6f 72 45 61 63 68 43 | 68 69 6c 64 52 65 6c 28 |ForEachC|hildRel(|
|00003db0| 29 20 7b 0d 0a 20 20 25 | 52 65 6c 54 65 6d 70 6c |) {.. %|RelTempl|
|00003dc0| 61 74 65 0d 0a 7d 0d 0a | 25 46 6f 72 45 61 63 68 |ate..}..|%ForEach|
|00003dd0| 50 61 72 65 6e 74 52 65 | 6c 28 29 20 7b 0d 0a 20 |ParentRe|l() {.. |
|00003de0| 20 25 52 65 6c 54 65 6d | 70 6c 61 74 65 0d 0a 7d | %RelTem|plate..}|
|00003df0| 0d 0a 20 20 72 65 74 75 | 72 6e 0d 0a 65 72 72 6f |.. retu|rn..erro|
|00003e00| 72 3a 0d 0a 20 20 20 20 | 72 61 69 73 65 72 72 6f |r:.. |raiserro|
|00003e10| 72 20 40 65 72 72 6e 6f | 20 40 65 72 72 6d 73 67 |r @errno| @errmsg|
|00003e20| 0d 0a 20 20 20 20 72 6f | 6c 6c 62 61 63 6b 20 74 |.. ro|llback t|
|00003e30| 72 61 6e 73 61 63 74 69 | 6f 6e 0d 0a 65 6e 64 0d |ransacti|on..end.|
|00003e40| 0a 67 6f 0d 0a 30 27 00 | 00 00 00 00 00 09 00 00 |.go..0'.|........|
|00003e50| 00 01 00 00 00 0f 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003e60| 00 00 00 02 00 00 00 1e | 00 00 00 00 00 00 00 00 |........|........|
|00003e70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003e80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003e90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ea0| 00 00 00 00 00 00 05 00 | 00 00 19 00 50 41 52 45 |........|....PARE|
|00003eb0| 4e 54 20 55 50 44 41 54 | 45 20 53 45 54 20 44 45 |NT UPDAT|E SET DE|
|00003ec0| 46 41 55 4c 54 92 00 2f | 2a 20 45 52 77 69 6e 20 |FAULT../|* ERwin |
|00003ed0| 42 75 69 6c 74 69 6e 20 | 25 44 61 74 65 74 69 6d |Builtin |%Datetim|
|00003ee0| 65 20 2a 2f 0d 0a 2f 2a | 20 25 50 61 72 65 6e 74 |e */../*| %Parent|
|00003ef0| 20 25 56 65 72 62 50 68 | 72 61 73 65 20 25 43 68 | %VerbPh|rase %Ch|
|00003f00| 69 6c 64 20 4f 4e 20 50 | 41 52 45 4e 54 20 55 50 |ild ON P|ARENT UP|
|00003f10| 44 41 54 45 20 53 45 54 | 20 44 45 46 41 55 4c 54 |DATE SET| DEFAULT|
|00003f20| 20 2a 2f 0d 0a 2f 2a 20 | 41 70 70 6c 69 63 61 74 | */../* |Applicat|
|00003f30| 69 6f 6e 20 73 70 65 63 | 69 66 69 63 2e 20 20 4c |ion spec|ific. L|
|00003f40| 65 66 74 20 6f 75 74 20 | 69 6e 74 65 6e 74 69 6f |eft out |intentio|
|00003f50| 6e 61 6c 6c 79 2e 20 2a | 2f 13 27 00 00 00 00 00 |nally. *|/.'.....|
|00003f60| 00 09 00 00 00 01 00 00 | 00 0f 00 00 00 00 00 00 |........|........|
|00003f70| 00 00 00 00 00 00 00 02 | 00 00 00 1e 00 00 00 00 |........|........|
|00003f80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003f90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003fa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003fb0| 00 00 00 00 00 00 00 00 | 00 00 05 00 00 00 19 00 |........|........|
|00003fc0| 50 41 52 45 4e 54 20 44 | 45 4c 45 54 45 20 53 45 |PARENT D|ELETE SE|
|00003fd0| 54 20 44 45 46 41 55 4c | 54 92 00 2f 2a 20 45 52 |T DEFAUL|T../* ER|
|00003fe0| 77 69 6e 20 42 75 69 6c | 74 69 6e 20 25 44 61 74 |win Buil|tin %Dat|
|00003ff0| 65 74 69 6d 65 20 2a 2f | 0d 0a 2f 2a 20 25 50 61 |etime */|../* %Pa|
|00004000| 72 65 6e 74 20 25 56 65 | 72 62 50 68 72 61 73 65 |rent %Ve|rbPhrase|
|00004010| 20 25 43 68 69 6c 64 20 | 4f 4e 20 50 41 52 45 4e | %Child |ON PAREN|
|00004020| 54 20 44 45 4c 45 54 45 | 20 53 45 54 20 44 45 46 |T DELETE| SET DEF|
|00004030| 41 55 4c 54 20 2a 2f 0d | 0a 2f 2a 20 41 70 70 6c |AULT */.|./* Appl|
|00004040| 69 63 61 74 69 6f 6e 20 | 73 70 65 63 69 66 69 63 |ication |specific|
|00004050| 2e 20 20 4c 65 66 74 20 | 6f 75 74 20 69 6e 74 65 |. Left |out inte|
|00004060| 6e 74 69 6f 6e 61 6c 6c | 79 2e 20 2a 2f 17 27 00 |ntionall|y. */.'.|
|00004070| 00 00 00 00 00 09 00 00 | 00 01 00 00 00 0f 00 00 |........|........|
|00004080| 00 00 00 00 00 00 00 00 | 00 00 00 02 00 00 00 1e |........|........|
|00004090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000040a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000040b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000040c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 05 00 |........|........|
|000040d0| 00 00 19 00 50 41 52 45 | 4e 54 20 49 4e 53 45 52 |....PARE|NT INSER|
|000040e0| 54 20 53 45 54 20 44 45 | 46 41 55 4c 54 92 00 2f |T SET DE|FAULT../|
|000040f0| 2a 20 45 52 77 69 6e 20 | 42 75 69 6c 74 69 6e 20 |* ERwin |Builtin |
|00004100| 25 44 61 74 65 74 69 6d | 65 20 2a 2f 0d 0a 2f 2a |%Datetim|e */../*|
|00004110| 20 25 50 61 72 65 6e 74 | 20 25 56 65 72 62 50 68 | %Parent| %VerbPh|
|00004120| 72 61 73 65 20 25 43 68 | 69 6c 64 20 4f 4e 20 50 |rase %Ch|ild ON P|
|00004130| 41 52 45 4e 54 20 49 4e | 53 45 52 54 20 53 45 54 |ARENT IN|SERT SET|
|00004140| 20 44 45 46 41 55 4c 54 | 20 2a 2f 0d 0a 2f 2a 20 | DEFAULT| */../* |
|00004150| 41 70 70 6c 69 63 61 74 | 69 6f 6e 20 73 70 65 63 |Applicat|ion spec|
|00004160| 69 66 69 63 2e 20 20 4c | 65 66 74 20 6f 75 74 20 |ific. L|eft out |
|00004170| 69 6e 74 65 6e 74 69 6f | 6e 61 6c 6c 79 2e 20 2a |intentio|nally. *|
|00004180| 2f 27 27 00 00 00 00 00 | 00 09 00 00 00 01 00 00 |/''.....|........|
|00004190| 00 0f 00 00 00 00 00 00 | 00 00 00 00 00 00 00 02 |........|........|
|000041a0| 00 00 00 1e 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000041b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000041c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000041d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000041e0| 00 00 05 00 00 00 18 00 | 43 48 49 4c 44 20 49 4e |........|CHILD IN|
|000041f0| 53 45 52 54 20 53 45 54 | 20 44 45 46 41 55 4c 54 |SERT SET| DEFAULT|
|00004200| 91 00 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 |../* ERw|in Built|
|00004210| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|00004220| 0a 2f 2a 20 25 50 61 72 | 65 6e 74 20 25 56 65 72 |./* %Par|ent %Ver|
|00004230| 62 50 68 72 61 73 65 20 | 25 43 68 69 6c 64 20 4f |bPhrase |%Child O|
|00004240| 4e 20 43 48 49 4c 44 20 | 49 4e 53 45 52 54 20 53 |N CHILD |INSERT S|
|00004250| 45 54 20 44 45 46 41 55 | 4c 54 20 2a 2f 0d 0a 2f |ET DEFAU|LT */../|
|00004260| 2a 20 41 70 70 6c 69 63 | 61 74 69 6f 6e 20 73 70 |* Applic|ation sp|
|00004270| 65 63 69 66 69 63 2e 20 | 20 4c 65 66 74 20 6f 75 |ecific. | Left ou|
|00004280| 74 20 69 6e 74 65 6e 74 | 69 6f 6e 61 6c 6c 79 2e |t intent|ionally.|
|00004290| 20 2a 2f 1b 27 00 00 00 | 00 00 00 09 00 00 00 01 | */.'...|........|
|000042a0| 00 00 00 0f 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000042b0| 00 02 00 00 00 1e 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000042c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000042d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000042e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000042f0| 00 00 00 00 05 00 00 00 | 18 00 43 48 49 4c 44 20 |........|..CHILD |
|00004300| 55 50 44 41 54 45 20 53 | 45 54 20 44 45 46 41 55 |UPDATE S|ET DEFAU|
|00004310| 4c 54 91 00 2f 2a 20 45 | 52 77 69 6e 20 42 75 69 |LT../* E|Rwin Bui|
|00004320| 6c 74 69 6e 20 25 44 61 | 74 65 74 69 6d 65 20 2a |ltin %Da|tetime *|
|00004330| 2f 0d 0a 2f 2a 20 25 50 | 61 72 65 6e 74 20 25 56 |/../* %P|arent %V|
|00004340| 65 72 62 50 68 72 61 73 | 65 20 25 43 68 69 6c 64 |erbPhras|e %Child|
|00004350| 20 4f 4e 20 43 48 49 4c | 44 20 55 50 44 41 54 45 | ON CHIL|D UPDATE|
|00004360| 20 53 45 54 20 44 45 46 | 41 55 4c 54 20 2a 2f 0d | SET DEF|AULT */.|
|00004370| 0a 2f 2a 20 41 70 70 6c | 69 63 61 74 69 6f 6e 20 |./* Appl|ication |
|00004380| 73 70 65 63 69 66 69 63 | 2e 20 20 4c 65 66 74 20 |specific|. Left |
|00004390| 6f 75 74 20 69 6e 74 65 | 6e 74 69 6f 6e 61 6c 6c |out inte|ntionall|
|000043a0| 79 2e 20 2a 2f 1f 27 00 | 00 00 00 00 00 09 00 00 |y. */.'.|........|
|000043b0| 00 01 00 00 00 0f 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000043c0| 00 00 00 02 00 00 00 1e | 00 00 00 00 00 00 00 00 |........|........|
|000043d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000043e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000043f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004400| 00 00 00 00 00 00 05 00 | 00 00 18 00 43 48 49 4c |........|....CHIL|
|00004410| 44 20 44 45 4c 45 54 45 | 20 53 45 54 20 44 45 46 |D DELETE| SET DEF|
|00004420| 41 55 4c 54 91 00 2f 2a | 20 45 52 77 69 6e 20 42 |AULT../*| ERwin B|
|00004430| 75 69 6c 74 69 6e 20 25 | 44 61 74 65 74 69 6d 65 |uiltin %|Datetime|
|00004440| 20 2a 2f 0d 0a 2f 2a 20 | 25 50 61 72 65 6e 74 20 | */../* |%Parent |
|00004450| 25 56 65 72 62 50 68 72 | 61 73 65 20 25 43 68 69 |%VerbPhr|ase %Chi|
|00004460| 6c 64 20 4f 4e 20 43 48 | 49 4c 44 20 44 45 4c 45 |ld ON CH|ILD DELE|
|00004470| 54 45 20 53 45 54 20 44 | 45 46 41 55 4c 54 20 2a |TE SET D|EFAULT *|
|00004480| 2f 0d 0a 2f 2a 20 41 70 | 70 6c 69 63 61 74 69 6f |/../* Ap|plicatio|
|00004490| 6e 20 73 70 65 63 69 66 | 69 63 2e 20 20 4c 65 66 |n specif|ic. Lef|
|000044a0| 74 20 6f 75 74 20 69 6e | 74 65 6e 74 69 6f 6e 61 |t out in|tentiona|
|000044b0| 6c 6c 79 2e 20 2a 2f 23 | 27 00 00 00 00 00 00 09 |lly. */#|'.......|
|000044c0| 00 00 00 01 00 00 00 0f | 00 00 00 00 00 00 00 00 |........|........|
|000044d0| 00 00 00 00 00 02 00 00 | 00 1e 00 00 00 00 00 00 |........|........|
|000044e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000044f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004500| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004510| 00 00 00 00 00 00 00 00 | 05 00 00 00 15 00 43 48 |........|......CH|
|00004520| 49 4c 44 20 44 45 4c 45 | 54 45 20 53 45 54 20 4e |ILD DELE|TE SET N|
|00004530| 55 4c 4c 8e 00 2f 2a 20 | 45 52 77 69 6e 20 42 75 |ULL../* |ERwin Bu|
|00004540| 69 6c 74 69 6e 20 25 44 | 61 74 65 74 69 6d 65 20 |iltin %D|atetime |
|00004550| 2a 2f 0d 0a 2f 2a 20 25 | 50 61 72 65 6e 74 20 25 |*/../* %|Parent %|
|00004560| 56 65 72 62 50 68 72 61 | 73 65 20 25 43 68 69 6c |VerbPhra|se %Chil|
|00004570| 64 20 4f 4e 20 43 48 49 | 4c 44 20 44 45 4c 45 54 |d ON CHI|LD DELET|
|00004580| 45 20 53 45 54 20 4e 55 | 4c 4c 20 2a 2f 0d 0a 2f |E SET NU|LL */../|
|00004590| 2a 20 41 70 70 6c 69 63 | 61 74 69 6f 6e 20 73 70 |* Applic|ation sp|
|000045a0| 65 63 69 66 69 63 2e 20 | 20 4c 65 66 74 20 6f 75 |ecific. | Left ou|
|000045b0| 74 20 69 6e 74 65 6e 74 | 69 6f 6e 61 6c 6c 79 2e |t intent|ionally.|
|000045c0| 20 2a 2f 22 27 00 00 00 | 00 00 00 09 00 00 00 01 | */"'...|........|
|000045d0| 00 00 00 0f 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000045e0| 00 02 00 00 00 1e 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000045f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004600| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004610| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004620| 00 00 00 00 05 00 00 00 | 16 00 50 41 52 45 4e 54 |........|..PARENT|
|00004630| 20 49 4e 53 45 52 54 20 | 53 45 54 20 4e 55 4c 4c | INSERT |SET NULL|
|00004640| 8f 00 2f 2a 20 45 52 77 | 69 6e 20 42 75 69 6c 74 |../* ERw|in Built|
|00004650| 69 6e 20 25 44 61 74 65 | 74 69 6d 65 20 2a 2f 0d |in %Date|time */.|
|00004660| 0a 2f 2a 20 25 50 61 72 | 65 6e 74 20 25 56 65 72 |./* %Par|ent %Ver|
|00004670| 62 50 68 72 61 73 65 20 | 25 43 68 69 6c 64 20 4f |bPhrase |%Child O|
|00004680| 4e 20 50 41 52 45 4e 54 | 20 49 4e 53 45 52 54 20 |N PARENT| INSERT |
|00004690| 53 45 54 20 4e 55 4c 4c | 20 2a 2f 0d 0a 2f 2a 20 |SET NULL| */../* |
|000046a0| 41 70 70 6c 69 63 61 74 | 69 6f 6e 20 73 70 65 63 |Applicat|ion spec|
|000046b0| 69 66 69 63 2e 20 20 4c | 65 66 74 20 6f 75 74 20 |ific. L|eft out |
|000046c0| 69 6e 74 65 6e 74 69 6f | 6e 61 6c 6c 79 2e 20 2a |intentio|nally. *|
|000046d0| 2f 26 27 00 00 00 00 00 | 00 09 00 00 00 01 00 00 |/&'.....|........|
|000046e0| 00 0f 00 00 00 00 00 00 | 00 00 00 00 00 00 00 02 |........|........|
|000046f0| 00 00 00 1e 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004700| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004710| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004720| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004730| 00 00 05 00 00 00 15 00 | 50 41 52 45 4e 54 20 49 |........|PARENT I|
|00004740| 4e 53 45 52 54 20 43 41 | 53 43 41 44 45 8e 00 2f |NSERT CA|SCADE../|
|00004750| 2a 20 45 52 77 69 6e 20 | 42 75 69 6c 74 69 6e 20 |* ERwin |Builtin |
|00004760| 25 44 61 74 65 74 69 6d | 65 20 2a 2f 0d 0a 2f 2a |%Datetim|e */../*|
|00004770| 20 25 50 61 72 65 6e 74 | 20 25 56 65 72 62 50 68 | %Parent| %VerbPh|
|00004780| 72 61 73 65 20 25 43 68 | 69 6c 64 20 4f 4e 20 50 |rase %Ch|ild ON P|
|00004790| 41 52 45 4e 54 20 49 4e | 53 45 52 54 20 43 41 53 |ARENT IN|SERT CAS|
|000047a0| 43 41 44 45 20 2a 2f 0d | 0a 2f 2a 20 41 70 70 6c |CADE */.|./* Appl|
|000047b0| 69 63 61 74 69 6f 6e 20 | 73 70 65 63 69 66 69 63 |ication |specific|
|000047c0| 2e 20 20 4c 65 66 74 20 | 6f 75 74 20 69 6e 74 65 |. Left |out inte|
|000047d0| 6e 74 69 6f 6e 61 6c 6c | 79 2e 20 2a 2f 25 27 00 |ntionall|y. */%'.|
|000047e0| 00 00 00 00 00 09 00 00 | 00 01 00 00 00 0f 00 00 |........|........|
|000047f0| 00 00 00 00 00 00 00 00 | 00 00 00 02 00 00 00 1e |........|........|
|00004800| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004810| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004820| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004830| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 02 00 |........|........|
|00004840| 00 00 03 00 0d 00 54 65 | 6d 70 6c 61 74 65 20 4e |......Te|mplate N|
|00004850| 61 6d 65 22 00 00 00 00 | 02 00 0f 00 54 65 6d 70 |ame"....|....Temp|
|00004860| 6c 61 74 65 20 48 61 6e | 64 6c 65 00 00 00 00 00 |late Han|dle.....|
|00004870| 00 00 00 00 03 00 00 00 | 01 00 0c 00 50 75 72 70 |........|....Purp|
|00004880| 6f 73 65 20 54 65 78 74 | 22 00 00 00 00 00 00 07 |ose Text|".......|
|00004890| 00 50 75 72 70 6f 73 65 | 00 00 00 00 00 02 00 0f |.Purpose|........|
|000048a0| 00 54 65 6d 70 6c 61 74 | 65 20 48 61 6e 64 6c 65 |.Templat|e Handle|
|000048b0| 22 00 00 00 00 22 00 00 | 00 03 00 00 00 14 00 43 |"...."..|.......C|
|000048c0| 48 49 4c 44 20 44 45 4c | 45 54 45 20 43 41 53 43 |HILD DEL|ETE CASC|
|000048d0| 41 44 45 21 27 00 00 21 | 27 ff ff 03 00 00 00 15 |ADE!'..!|'.......|
|000048e0| 00 43 48 49 4c 44 20 44 | 45 4c 45 54 45 20 52 45 |.CHILD D|ELETE RE|
|000048f0| 53 54 52 49 43 54 20 27 | 00 00 20 27 ff ff 03 00 |STRICT '|.. '....|
|00004900| 00 00 18 00 43 48 49 4c | 44 20 44 45 4c 45 54 45 |....CHIL|D DELETE|
|00004910| 20 53 45 54 20 44 45 46 | 41 55 4c 54 23 27 00 00 | SET DEF|AULT#'..|
|00004920| 23 27 ff ff 03 00 00 00 | 15 00 43 48 49 4c 44 20 |#'......|..CHILD |
|00004930| 44 45 4c 45 54 45 20 53 | 45 54 20 4e 55 4c 4c 22 |DELETE S|ET NULL"|
|00004940| 27 00 00 22 27 ff ff 03 | 00 00 00 14 00 43 48 49 |'.."'...|.....CHI|
|00004950| 4c 44 20 49 4e 53 45 52 | 54 20 43 41 53 43 41 44 |LD INSER|T CASCAD|
|00004960| 45 19 27 00 00 19 27 ff | ff 03 00 00 00 15 00 43 |E.'...'.|.......C|
|00004970| 48 49 4c 44 20 49 4e 53 | 45 52 54 20 52 45 53 54 |HILD INS|ERT REST|
|00004980| 52 49 43 54 18 27 00 00 | 18 27 ff ff 03 00 00 00 |RICT.'..|.'......|
|00004990| 18 00 43 48 49 4c 44 20 | 49 4e 53 45 52 54 20 53 |..CHILD |INSERT S|
|000049a0| 45 54 20 44 45 46 41 55 | 4c 54 1b 27 00 00 1b 27 |ET DEFAU|LT.'...'|
|000049b0| ff ff 03 00 00 00 15 00 | 43 48 49 4c 44 20 49 4e |........|CHILD IN|
|000049c0| 53 45 52 54 20 53 45 54 | 20 4e 55 4c 4c 1a 27 00 |SERT SET| NULL.'.|
|000049d0| 00 1a 27 ff ff 03 00 00 | 00 14 00 43 48 49 4c 44 |..'.....|...CHILD|
|000049e0| 20 55 50 44 41 54 45 20 | 43 41 53 43 41 44 45 1d | UPDATE |CASCADE.|
|000049f0| 27 00 00 1d 27 ff ff 03 | 00 00 00 15 00 43 48 49 |'...'...|.....CHI|
|00004a00| 4c 44 20 55 50 44 41 54 | 45 20 52 45 53 54 52 49 |LD UPDAT|E RESTRI|
|00004a10| 43 54 1c 27 00 00 1c 27 | ff ff 03 00 00 00 18 00 |CT.'...'|........|
|00004a20| 43 48 49 4c 44 20 55 50 | 44 41 54 45 20 53 45 54 |CHILD UP|DATE SET|
|00004a30| 20 44 45 46 41 55 4c 54 | 1f 27 00 00 1f 27 ff ff | DEFAULT|.'...'..|
|00004a40| 03 00 00 00 15 00 43 48 | 49 4c 44 20 55 50 44 41 |......CH|ILD UPDA|
|00004a50| 54 45 20 53 45 54 20 4e | 55 4c 4c 1e 27 00 00 1e |TE SET N|ULL.'...|
|00004a60| 27 ff ff 03 00 00 00 1b | 00 43 55 53 54 4f 4d 20 |'.......|.CUSTOM |
|00004a70| 54 52 49 47 47 45 52 20 | 44 45 46 41 55 4c 54 20 |TRIGGER |DEFAULT |
|00004a80| 42 4f 44 59 30 27 00 00 | 30 27 ff ff 03 00 00 00 |BODY0'..|0'......|
|00004a90| 15 00 43 55 53 54 4f 4d | 20 54 52 49 47 47 45 52 |..CUSTOM| TRIGGER|
|00004aa0| 20 46 4f 4f 54 45 52 2f | 27 00 00 2f 27 ff ff 03 | FOOTER/|'../'...|
|00004ab0| 00 00 00 15 00 43 55 53 | 54 4f 4d 20 54 52 49 47 |.....CUS|TOM TRIG|
|00004ac0| 47 45 52 20 48 45 41 44 | 45 52 2e 27 00 00 2e 27 |GER HEAD|ER.'...'|
|00004ad0| ff ff 03 00 00 00 15 00 | 50 41 52 45 4e 54 20 44 |........|PARENT D|
|00004ae0| 45 4c 45 54 45 20 43 41 | 53 43 41 44 45 15 27 00 |ELETE CA|SCADE.'.|
|00004af0| 00 15 27 ff ff 03 00 00 | 00 16 00 50 41 52 45 4e |..'.....|...PAREN|
|00004b00| 54 20 44 45 4c 45 54 45 | 20 52 45 53 54 52 49 43 |T DELETE| RESTRIC|
|00004b10| 54 14 27 00 00 14 27 ff | ff 03 00 00 00 19 00 50 |T.'...'.|.......P|
|00004b20| 41 52 45 4e 54 20 44 45 | 4c 45 54 45 20 53 45 54 |ARENT DE|LETE SET|
|00004b30| 20 44 45 46 41 55 4c 54 | 17 27 00 00 17 27 ff ff | DEFAULT|.'...'..|
|00004b40| 03 00 00 00 16 00 50 41 | 52 45 4e 54 20 44 45 4c |......PA|RENT DEL|
|00004b50| 45 54 45 20 53 45 54 20 | 4e 55 4c 4c 16 27 00 00 |ETE SET |NULL.'..|
|00004b60| 16 27 ff ff 03 00 00 00 | 15 00 50 41 52 45 4e 54 |.'......|..PARENT|
|00004b70| 20 49 4e 53 45 52 54 20 | 43 41 53 43 41 44 45 25 | INSERT |CASCADE%|
|00004b80| 27 00 00 25 27 ff ff 03 | 00 00 00 16 00 50 41 52 |'..%'...|.....PAR|
|00004b90| 45 4e 54 20 49 4e 53 45 | 52 54 20 52 45 53 54 52 |ENT INSE|RT RESTR|
|00004ba0| 49 43 54 24 27 00 00 24 | 27 ff ff 03 00 00 00 19 |ICT$'..$|'.......|
|00004bb0| 00 50 41 52 45 4e 54 20 | 49 4e 53 45 52 54 20 53 |.PARENT |INSERT S|
|00004bc0| 45 54 20 44 45 46 41 55 | 4c 54 27 27 00 00 27 27 |ET DEFAU|LT''..''|
|00004bd0| ff ff 03 00 00 00 16 00 | 50 41 52 45 4e 54 20 49 |........|PARENT I|
|00004be0| 4e 53 45 52 54 20 53 45 | 54 20 4e 55 4c 4c 26 27 |NSERT SE|T NULL&'|
|00004bf0| 00 00 26 27 ff ff 03 00 | 00 00 15 00 50 41 52 45 |..&'....|....PARE|
|00004c00| 4e 54 20 55 50 44 41 54 | 45 20 43 41 53 43 41 44 |NT UPDAT|E CASCAD|
|00004c10| 45 11 27 00 00 11 27 ff | ff 03 00 00 00 16 00 50 |E.'...'.|.......P|
|00004c20| 41 52 45 4e 54 20 55 50 | 44 41 54 45 20 52 45 53 |ARENT UP|DATE RES|
|00004c30| 54 52 49 43 54 10 27 00 | 00 10 27 ff ff 03 00 00 |TRICT.'.|..'.....|
|00004c40| 00 19 00 50 41 52 45 4e | 54 20 55 50 44 41 54 45 |...PAREN|T UPDATE|
|00004c50| 20 53 45 54 20 44 45 46 | 41 55 4c 54 13 27 00 00 | SET DEF|AULT.'..|
|00004c60| 13 27 ff ff 03 00 00 00 | 16 00 50 41 52 45 4e 54 |.'......|..PARENT|
|00004c70| 20 55 50 44 41 54 45 20 | 53 45 54 20 4e 55 4c 4c | UPDATE |SET NULL|
|00004c80| 12 27 00 00 12 27 ff ff | 03 00 00 00 14 00 52 41 |.'...'..|......RA|
|00004c90| 49 53 45 20 45 58 43 45 | 50 54 49 4f 4e 20 50 52 |ISE EXCE|PTION PR|
|00004ca0| 4f 43 31 27 00 00 00 00 | ff ff 03 00 00 00 15 00 |OC1'....|........|
|00004cb0| 54 52 49 47 47 45 52 20 | 44 45 4c 45 54 45 20 46 |TRIGGER |DELETE F|
|00004cc0| 4f 4f 54 45 52 2b 27 00 | 00 2b 27 ff ff 03 00 00 |OOTER+'.|.+'.....|
|00004cd0| 00 15 00 54 52 49 47 47 | 45 52 20 44 45 4c 45 54 |...TRIGG|ER DELET|
|00004ce0| 45 20 48 45 41 44 45 52 | 2a 27 00 00 2a 27 ff ff |E HEADER|*'..*'..|
|00004cf0| 03 00 00 00 15 00 54 52 | 49 47 47 45 52 20 49 4e |......TR|IGGER IN|
|00004d00| 53 45 52 54 20 46 4f 4f | 54 45 52 2d 27 00 00 2d |SERT FOO|TER-'..-|
|00004d10| 27 ff ff 03 00 00 00 15 | 00 54 52 49 47 47 45 52 |'.......|.TRIGGER|
|00004d20| 20 49 4e 53 45 52 54 20 | 48 45 41 44 45 52 2c 27 | INSERT |HEADER,'|
|00004d30| 00 00 2c 27 ff ff 03 00 | 00 00 15 00 54 52 49 47 |..,'....|....TRIG|
|00004d40| 47 45 52 20 55 50 44 41 | 54 45 20 46 4f 4f 54 45 |GER UPDA|TE FOOTE|
|00004d50| 52 29 27 00 00 29 27 ff | ff 03 00 00 00 15 00 54 |R)'..)'.|.......T|
|00004d60| 52 49 47 47 45 52 20 55 | 50 44 41 54 45 20 48 45 |RIGGER U|PDATE HE|
|00004d70| 41 44 45 52 28 27 00 00 | 28 27 ff ff 06 00 00 00 |ADER('..|('......|
|00004d80| 01 00 00 00 23 00 00 00 | 00 01 00 00 00 40 00 00 |....#...|.....@..|
|00004d90| 00 00 00 00 00 00 09 00 | 00 00 00 04 00 00 00 00 |........|........|
|00004da0| 00 00 00 00 04 00 00 00 | 00 00 00 00 00 02 00 00 |........|........|
|00004db0| 00 00 00 00 00 00 00 00 | 00 00 01 00 00 00 02 00 |........|........|
|00004dc0| 00 00 00 00 00 00 00 00 | 00 00 00 06 00 00 00 01 |........|........|
|00004dd0| 00 00 00 23 00 00 00 00 | 01 00 00 00 40 00 00 00 |...#....|....@...|
|00004de0| 00 00 00 00 00 09 00 00 | 00 00 04 00 00 00 00 00 |........|........|
|00004df0| 00 00 00 04 00 00 00 00 | 00 00 00 00 02 00 00 00 |........|........|
|00004e00| 00 00 00 00 00 00 00 00 | 00 06 00 00 00 01 00 00 |........|........|
|00004e10| 00 1a 00 00 00 00 01 00 | 00 00 40 00 00 00 00 00 |........|..@.....|
|00004e20| 00 00 00 09 00 00 00 00 | 04 00 00 00 00 00 00 00 |........|........|
|00004e30| 00 04 00 00 00 00 00 00 | 00 00 02 00 00 00 00 00 |........|........|
|00004e40| 00 00 00 00 00 00 00 01 | 00 00 00 02 00 00 00 00 |........|........|
|00004e50| 00 00 00 00 00 00 00 00 | 06 00 00 00 01 00 00 00 |........|........|
|00004e60| 1a 00 00 00 00 01 00 00 | 00 40 00 00 00 00 00 00 |........|.@......|
|00004e70| 00 00 09 00 00 00 00 04 | 00 00 00 00 00 00 00 00 |........|........|
|00004e80| 04 00 00 00 00 00 00 00 | 00 02 00 00 00 00 00 00 |........|........|
|00004e90| 00 00 00 00 00 00 10 27 | 14 27 18 27 1c 27 00 00 |.......'|.'.'.'..|
|00004ea0| 00 00 00 00 12 27 16 27 | 1a 27 1e 27 00 00 00 00 |.....'.'|.'.'....|
|00004eb0| 00 00 10 27 14 27 18 27 | 1c 27 00 00 00 00 00 00 |...'.'.'|.'......|
|00004ec0| 11 27 15 27 18 27 1c 27 | 00 00 00 00 00 00 04 00 |.'.'.'.'|........|
|00004ed0| 00 00 02 00 00 00 1e 00 | 00 00 00 03 00 00 00 28 |........|.......(|
|00004ee0| 00 00 00 00 04 00 00 00 | 00 00 00 00 00 02 00 00 |........|........|
|00004ef0| 00 1e 00 00 00 00 00 00 | 00 00 04 00 00 00 02 00 |........|........|
|00004f00| 00 00 28 00 00 00 00 00 | 00 00 00 28 00 00 00 00 |..(.....|...(....|
|00004f10| 04 00 00 00 00 00 00 00 | 00 02 00 00 00 28 00 00 |........|.....(..|
|00004f20| 00 00 00 00 00 00 0d 00 | 00 00 01 00 00 00 28 00 |........|......(.|
|00004f30| 00 00 00 02 00 00 00 28 | 00 00 00 00 02 00 00 00 |.......(|........|
|00004f40| 00 00 00 00 00 02 00 00 | 00 00 00 00 00 00 01 00 |........|........|
|00004f50| 00 00 64 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |..d.....|........|
|00004f60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f70| 00 00 02 00 00 00 28 00 | 00 00 00 04 00 00 00 00 |......(.|........|
|00004f80| 00 00 00 00 02 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f90| 00 00 00 00 00 00 01 00 | 00 00 00 00 00 00 00 09 |........|........|
|00004fa0| 00 00 00 0d 00 00 00 09 | 00 3c 75 6e 6b 6e 6f 77 |........|.<unknow|
|00004fb0| 6e 3e 08 00 00 00 00 00 | 00 00 00 00 08 00 00 00 |n>......|........|
|00004fc0| 00 00 00 00 03 00 00 00 | 00 00 00 00 09 00 00 00 |........|........|
|00004fd0| 01 00 00 00 0f 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004fe0| 00 00 02 00 00 00 1e 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005000| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005020| 00 00 00 00 00 04 00 00 | 00 00 00 0d 00 00 00 04 |........|........|
|00005030| 00 42 6c 6f 62 00 00 00 | 00 02 00 00 00 00 00 00 |.Blob...|........|
|00005040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 01 |........|........|
|00005050| 00 00 00 02 00 00 00 02 | 00 00 00 06 00 62 69 6e |........|.....bin|
|00005060| 61 72 79 00 00 0c 00 00 | 00 00 00 00 00 08 00 00 |ary.....|........|
|00005070| 00 00 00 00 00 09 00 00 | 00 01 00 00 00 0f 00 00 |........|........|
|00005080| 00 00 00 00 00 00 00 00 | 00 00 00 02 00 00 00 1e |........|........|
|00005090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000050a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000050b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000050c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 03 00 |........|........|
|000050d0| 00 00 00 00 0d 00 00 00 | 08 00 44 61 74 65 74 69 |........|..Dateti|
|000050e0| 6d 65 00 00 00 00 02 00 | 00 00 00 00 00 00 00 00 |me......|........|
|000050f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00005100| 02 00 00 00 02 00 00 00 | 08 00 64 61 74 65 74 69 |........|..dateti|
|00005110| 6d 65 00 00 0b 00 00 00 | 00 00 00 00 07 00 00 00 |me......|........|
|00005120| 00 00 00 00 09 00 00 00 | 01 00 00 00 0f 00 00 00 |........|........|
|00005130| 00 00 00 00 00 00 00 00 | 00 00 02 00 00 00 1e 00 |........|........|
|00005140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 03 00 00 |........|........|
|00005180| 00 00 00 0d 00 00 00 06 | 00 4e 75 6d 62 65 72 00 |........|.Number.|
|00005190| 00 00 00 02 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000051a0| 00 00 00 00 00 00 00 00 | 00 01 00 00 00 02 00 00 |........|........|
|000051b0| 00 02 00 00 00 03 00 69 | 6e 74 00 00 0a 00 00 00 |.......i|nt......|
|000051c0| 00 00 00 00 06 00 00 00 | 00 00 00 00 09 00 00 00 |........|........|
|000051d0| 01 00 00 00 0f 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000051e0| 00 00 02 00 00 00 1e 00 | 00 00 00 00 00 00 00 00 |........|........|
|000051f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005200| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005210| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005220| 00 00 00 00 00 03 00 00 | 00 00 00 0d 00 00 00 05 |........|........|
|00005230| 00 50 68 6f 6e 65 03 00 | 00 00 02 00 00 00 00 00 |.Phone..|........|
|00005240| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005250| 02 00 00 00 02 00 00 00 | 02 00 00 00 03 00 69 6e |........|......in|
|00005260| 74 02 00 00 00 05 00 00 | 00 00 00 00 00 00 00 16 |t.......|........|
|00005270| 00 00 00 01 00 00 00 01 | 00 00 00 00 00 00 00 09 |........|........|
|00005280| 00 00 00 01 00 00 00 0f | 00 00 00 00 00 00 00 00 |........|........|
|00005290| 00 00 00 00 00 02 00 00 | 00 1e 00 00 00 00 00 00 |........|........|
|000052a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000052b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000052c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000052d0| 00 00 00 00 00 00 00 00 | 06 00 00 00 00 00 0d 00 |........|........|
|000052e0| 00 00 06 00 53 74 72 69 | 6e 67 00 00 00 00 02 00 |....Stri|ng......|
|000052f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005300| 00 00 00 00 01 00 00 00 | 02 00 00 00 02 00 00 00 |........|........|
|00005310| 0b 00 76 61 72 63 68 61 | 72 28 32 30 29 00 00 09 |..varcha|r(20)...|
|00005320| 00 00 00 00 00 00 00 05 | 00 00 00 00 00 00 00 09 |........|........|
|00005330| 00 00 00 01 00 00 00 0f | 00 00 00 00 00 00 00 00 |........|........|
|00005340| 00 00 00 00 00 02 00 00 | 00 1e 00 00 00 00 00 00 |........|........|
|00005350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005380| 00 00 00 00 00 00 00 00 | 03 00 00 00 00 00 0d 00 |........|........|
|00005390| 00 00 07 00 41 44 44 52 | 45 53 53 05 00 00 00 02 |....ADDR|ESS.....|
|000053a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000053b0| 00 00 00 00 00 02 00 00 | 00 02 00 00 00 02 00 00 |........|........|
|000053c0| 00 09 00 63 68 61 72 28 | 32 35 30 29 02 00 00 00 |...char(|250)....|
|000053d0| 05 00 00 00 01 00 00 00 | 00 00 15 00 00 00 01 00 |........|........|
|000053e0| 00 00 01 00 00 00 00 00 | 00 00 09 00 00 00 01 00 |........|........|
|000053f0| 00 00 0f 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005400| 02 00 00 00 1e 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005410| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005420| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005430| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005440| 00 00 00 05 00 00 00 00 | 00 0d 00 00 00 0b 00 50 |........|.......P|
|00005450| 45 52 53 4f 4e 5f 4e 41 | 4d 45 05 00 00 00 02 00 |ERSON_NA|ME......|
|00005460| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005470| 00 00 00 00 02 00 00 00 | 02 00 00 00 02 00 00 00 |........|........|
|00005480| 08 00 63 68 61 72 28 31 | 35 29 02 00 00 00 05 00 |..char(1|5)......|
|00005490| 00 00 01 00 00 00 00 00 | 17 00 00 00 01 00 00 00 |........|........|
|000054a0| 01 00 00 00 00 00 00 00 | 09 00 00 00 01 00 00 00 |........|........|
|000054b0| 0f 00 00 00 00 00 00 00 | 00 00 00 00 00 00 02 00 |........|........|
|000054c0| 00 00 1e 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000054d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000054e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000054f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005500| 00 05 00 00 00 00 00 0d | 00 00 00 00 00 ff ff ff |........|........|
|00005510| ff 02 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005520| 00 00 00 00 00 00 00 0f | 00 00 00 02 00 00 00 02 |........|........|
|00005530| 00 00 00 08 00 63 68 61 | 72 28 31 38 29 02 00 00 |.....cha|r(18)...|
|00005540| 00 05 00 00 00 00 00 00 | 00 02 00 00 00 01 00 00 |........|........|
|00005550| 00 08 00 25 41 74 74 4e | 61 6d 65 02 00 00 00 ea |...%AttN|ame.....|
|00005560| 03 00 00 09 00 25 41 74 | 74 4e 61 6d 65 3a 02 00 |.....%At|tName:..|
|00005570| 00 00 ec 03 00 00 08 00 | 25 41 74 74 4e 61 6d 65 |........|%AttName|
|00005580| 02 00 00 00 19 00 00 00 | 07 00 25 41 74 74 44 65 |........|..%AttDe|
|00005590| 66 02 00 00 00 1d 00 00 | 00 0a 00 25 44 6f 6d 61 |f.......|...%Doma|
|000055a0| 69 6e 44 65 66 02 00 00 | 00 1e 00 00 00 0b 00 25 |inDef...|.......%|
|000055b0| 44 6f 6d 61 69 6e 4e 61 | 6d 65 02 00 00 00 f6 03 |DomainNa|me......|
|000055c0| 00 00 07 00 25 41 74 74 | 44 65 66 02 00 00 00 eb |....%Att|Def.....|
|000055d0| 03 00 00 17 00 00 00 02 | 00 00 00 ed 03 00 00 19 |........|........|
|000055e0| 00 00 00 02 00 00 00 ee | 03 00 00 17 00 00 00 02 |........|........|
|000055f0| 00 00 00 f0 03 00 00 1a | 00 00 00 02 00 00 00 f4 |........|........|
|00005600| 03 00 00 6e 00 00 00 02 | 00 00 00 e2 05 00 00 79 |...n....|.......y|
|00005610| 00 00 00 00 00 07 00 00 | 00 00 00 00 00 04 00 00 |........|........|
|00005620| 00 00 00 00 00 09 00 00 | 00 01 00 00 00 0f 00 00 |........|........|
|00005630| 00 00 00 00 00 00 00 00 | 00 00 00 02 00 00 00 1e |........|........|
|00005640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005650| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005680| 00 00 00 00 01 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005690| 00 04 00 00 00 01 00 00 | 00 03 00 00 00 01 00 00 |........|........|
|000056a0| 00 04 00 00 00 01 00 00 | 00 02 00 00 00 01 00 00 |........|........|
|000056b0| 00 1b 00 00 00 53 51 4c | 20 53 65 72 76 65 72 00 |.....SQL| Server.|
|000056c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000056d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000056e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000056f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 20 |........|....... |
|00005700| 00 00 00 12 00 00 00 0b | 00 00 00 1d 00 00 00 04 |........|........|
|00005710| 00 00 00 61 00 00 00 04 | 00 00 00 94 00 00 00 01 |...a....|........|
|00005720| 00 00 00 00 00 00 00 00 | 00 00 00 09 00 00 00 01 |........|........|
|00005730| 00 00 00 0f 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005740| 00 02 00 00 00 1e 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005780| 00 00 00 00 09 00 00 00 | 01 00 00 00 0f 00 00 00 |........|........|
|00005790| 00 00 00 00 00 00 00 00 | 00 00 02 00 00 00 1e 00 |........|........|
|000057a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000057b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000057c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000057d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 0a |........|........|
|000057e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 90 |........|........|
|000057f0| 01 00 00 00 00 00 00 07 | 02 01 22 41 72 69 61 6c |........|.."Arial|
|00005800| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005810| 00 00 00 00 00 00 00 00 | 00 00 00 f3 ff 02 00 0c |........|........|
|00005820| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 bc |........|........|
|00005830| 02 00 00 00 00 00 00 07 | 02 01 22 41 72 69 61 6c |........|.."Arial|
|00005840| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005850| 00 00 00 00 00 00 00 00 | 00 00 00 f0 ff ff ff 00 |........|........|
|00005860| 00 00 00 ff ff ff ff 00 | 00 00 00 00 00 ff ff 00 |........|........|
|00005870| 00 00 00 00 00 01 00 ff | ff ff 00 02 00 80 00 00 |........|........|
|00005880| 00 03 00 00 00 80 00 04 | 00 ff 00 00 00 05 00 00 |........|........|
|00005890| ff ff 00 06 00 ff 00 ff | 00 07 00 80 80 80 00 ff |........|........|
|000058a0| ff 00 00 00 00 ff ff ff | ff 00 00 00 00 03 00 04 |........|........|
|000058b0| 00 07 00 03 00 01 00 01 | 00 ff ff ff 00 ff ff ff |........|........|
|000058c0| 00 ff ff ff 00 ff ff ff | 00 ff ff ff 00 ff ff ff |........|........|
|000058d0| 00 ff ff ff 00 ff ff ff | 00 ff ff ff 00 ff ff ff |........|........|
|000058e0| 00 ff ff ff 00 ff ff ff | 00 ff ff ff 00 ff ff ff |........|........|
|000058f0| 00 ff ff ff 00 ff ff ff | 00 05 00 05 00 01 09 00 |........|........|
|00005900| 00 00 05 00 00 00 00 00 | 00 00 00 00 0a 00 00 00 |........|........|
|00005910| 05 00 00 00 00 00 00 00 | 00 00 0b 00 00 00 05 00 |........|........|
|00005920| 00 00 00 00 00 00 00 00 | 0c 00 00 00 05 00 00 00 |........|........|
|00005930| 00 00 00 00 00 00 0d 00 | 00 00 05 00 00 00 00 00 |........|........|
|00005940| 00 00 00 00 0e 00 00 00 | 05 00 00 00 00 00 00 00 |........|........|
|00005950| 00 00 0f 00 00 00 05 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005960| 10 00 00 00 05 00 00 00 | 00 00 00 00 00 00 11 00 |........|........|
|00005970| 00 00 05 00 00 00 00 00 | 00 00 00 00 12 00 00 00 |........|........|
|00005980| 05 00 00 00 00 00 00 00 | 00 00 13 00 00 00 05 00 |........|........|
|00005990| 00 00 00 00 00 00 00 00 | 14 00 00 00 05 00 00 00 |........|........|
|000059a0| 00 00 00 00 00 00 18 00 | 00 00 06 00 00 00 00 00 |........|........|
|000059b0| 00 00 00 00 19 00 00 00 | 06 00 00 00 00 00 00 00 |........|........|
|000059c0| 00 00 1a 00 00 00 06 00 | 00 00 00 00 00 00 00 00 |........|........|
|000059d0| 1b 00 00 00 06 00 00 00 | 00 00 00 00 00 00 1e 00 |........|........|
|000059e0| 00 00 09 00 00 00 11 00 | 67 65 6e 65 72 61 6c 20 |........|general |
|000059f0| 63 6f 6e 64 69 74 69 6f | 6e 00 00 00 00 1f 00 00 |conditio|n.......|
|00005a00| 00 09 00 00 00 11 00 6d | 6f 76 69 65 20 63 6f 70 |.......m|ovie cop|
|00005a10| 79 20 6e 75 6d 62 65 72 | 00 00 00 00 20 00 00 00 |y number|.... ...|
|00005a20| 0a 00 00 00 0e 00 6f 76 | 65 72 64 75 65 20 63 68 |......ov|erdue ch|
|00005a30| 61 72 67 65 00 00 00 00 | 24 00 00 00 0a 00 00 00 |arge....|$.......|
|00005a40| 0d 00 72 65 6e 74 61 6c | 20 73 74 61 74 75 73 00 |..rental| status.|
|00005a50| 00 00 00 25 00 00 00 0a | 00 00 00 08 00 64 75 65 |...%....|.....due|
|00005a60| 20 64 61 74 65 00 00 00 | 00 26 00 00 00 0a 00 00 | date...|.&......|
|00005a70| 00 0b 00 72 65 6e 74 61 | 6c 20 64 61 74 65 00 00 |...renta|l date..|
|00005a80| 00 00 27 00 00 00 0a 00 | 00 00 12 00 72 65 6e 74 |..'.....|....rent|
|00005a90| 61 6c 20 72 65 63 6f 72 | 64 20 64 61 74 65 00 00 |al recor|d date..|
|00005aa0| 00 00 28 00 00 00 0b 00 | 00 00 10 00 63 72 65 64 |..(.....|....cred|
|00005ab0| 69 74 5f 63 61 72 64 5f | 74 79 70 65 00 00 00 00 |it_card_|type....|
|00005ac0| 29 00 00 00 0b 00 00 00 | 16 00 63 72 65 64 69 74 |).......|..credit|
|00005ad0| 5f 63 61 72 64 5f 65 78 | 70 69 72 61 74 69 6f 6e |_card_ex|piration|
|00005ae0| 00 00 00 00 2a 00 00 00 | 0b 00 00 00 12 00 63 72 |....*...|......cr|
|00005af0| 65 64 69 74 5f 63 61 72 | 64 5f 6e 75 6d 62 65 72 |edit_car|d_number|
|00005b00| 00 00 00 00 2b 00 00 00 | 0b 00 00 00 0c 00 63 68 |....+...|......ch|
|00005b10| 65 63 6b 5f 6e 75 6d 62 | 65 72 00 00 00 00 2c 00 |eck_numb|er....,.|
|00005b20| 00 00 0b 00 00 00 11 00 | 63 68 65 63 6b 5f 62 61 |........|check_ba|
|00005b30| 6e 6b 5f 6e 75 6d 62 65 | 72 00 00 00 00 2f 00 00 |nk_numbe|r..../..|
|00005b40| 00 0b 00 00 00 06 00 73 | 74 61 74 75 73 00 00 00 |.......s|tatus...|
|00005b50| 00 30 00 00 00 0b 00 00 | 00 04 00 64 61 74 65 00 |.0......|...date.|
|00005b60| 00 00 00 31 00 00 00 0b | 00 00 00 06 00 61 6d 6f |...1....|.....amo|
|00005b70| 75 6e 74 00 00 00 00 32 | 00 00 00 0b 00 00 00 04 |unt....2|........|
|00005b80| 00 74 79 70 65 00 00 00 | 00 33 00 00 00 0b 00 00 |.type...|.3......|
|00005b90| 00 1a 00 70 61 79 6d 65 | 6e 74 20 74 72 61 6e 73 |...payme|nt trans|
|00005ba0| 61 63 74 69 6f 6e 20 6e | 75 6d 62 65 72 00 00 00 |action n|umber...|
|00005bb0| 00 34 00 00 00 0c 00 00 | 00 06 00 73 61 6c 61 72 |.4......|...salar|
|00005bc0| 79 00 00 00 00 35 00 00 | 00 0c 00 00 00 09 00 68 |y....5..|.......h|
|00005bd0| 69 72 65 5f 64 61 74 65 | 00 00 00 00 36 00 00 00 |ire_date|....6...|
|00005be0| 0c 00 00 00 03 00 73 73 | 23 00 00 00 00 37 00 00 |......ss|#....7..|
|00005bf0| 00 0c 00 00 00 05 00 70 | 68 6f 6e 65 00 00 00 00 |.......p|hone....|
|00005c00| 38 00 00 00 0c 00 00 00 | 0c 00 65 6d 70 6c 6f 79 |8.......|..employ|
|00005c10| 65 65 5f 7a 69 70 00 00 | 00 00 39 00 00 00 0c 00 |ee_zip..|..9.....|
|00005c20| 00 00 0e 00 65 6d 70 6c | 6f 79 65 65 5f 73 74 61 |....empl|oyee_sta|
|00005c30| 74 65 00 00 00 00 3a 00 | 00 00 0c 00 00 00 0d 00 |te....:.|........|
|00005c40| 65 6d 70 6c 6f 79 65 65 | 5f 63 69 74 79 00 00 00 |employee|_city...|
|00005c50| 00 3b 00 00 00 0c 00 00 | 00 12 00 65 6d 70 6c 6f |.;......|...emplo|
|00005c60| 79 65 65 5f 61 64 64 72 | 65 73 73 5f 32 00 00 00 |yee_addr|ess_2...|
|00005c70| 00 3c 00 00 00 0c 00 00 | 00 07 00 61 64 64 72 65 |.<......|...addre|
|00005c80| 73 73 00 00 00 00 3d 00 | 00 00 0c 00 00 00 12 00 |ss....=.|........|
|00005c90| 65 6d 70 6c 6f 79 65 65 | 20 6c 61 73 74 20 6e 61 |employee| last na|
|00005ca0| 6d 65 00 00 00 00 3e 00 | 00 00 0c 00 00 00 04 00 |me....>.|........|
|00005cb0| 6e 61 6d 65 00 00 00 00 | 3f 00 00 00 0c 00 00 00 |name....|?.......|
|00005cc0| 0f 00 65 6d 70 6c 6f 79 | 65 65 20 6e 75 6d 62 65 |..employ|ee numbe|
|00005cd0| 72 00 00 00 00 40 00 00 | 00 0d 00 00 00 05 00 70 |r....@..|.......p|
|00005ce0| 68 6f 6e 65 00 00 00 00 | 41 00 00 00 0d 00 00 00 |hone....|A.......|
|00005cf0| 09 00 73 74 6f 72 65 5f | 7a 69 70 00 00 00 00 42 |..store_|zip....B|
|00005d00| 00 00 00 0d 00 00 00 0b | 00 73 74 6f 72 65 5f 73 |........|.store_s|
|00005d10| 74 61 74 65 00 00 00 00 | 43 00 00 00 0d 00 00 00 |tate....|C.......|
|00005d20| 0a 00 73 74 6f 72 65 5f | 63 69 74 79 00 00 00 00 |..store_|city....|
|00005d30| 44 00 00 00 0d 00 00 00 | 0e 00 73 74 6f 72 65 5f |D.......|..store_|
|00005d40| 61 64 64 72 65 73 73 32 | 00 00 00 00 45 00 00 00 |address2|....E...|
|00005d50| 0d 00 00 00 07 00 61 64 | 64 72 65 73 73 00 00 00 |......ad|dress...|
|00005d60| 00 46 00 00 00 0d 00 00 | 00 07 00 6d 61 6e 61 67 |.F......|...manag|
|00005d70| 65 72 00 00 00 00 47 00 | 00 00 0d 00 00 00 0c 00 |er....G.|........|
|00005d80| 73 74 6f 72 65 20 6e 75 | 6d 62 65 72 00 00 00 00 |store nu|mber....|
|00005d90| 48 00 00 00 0e 00 00 00 | 0b 00 72 65 6e 74 61 6c |H.......|..rental|
|00005da0| 20 72 61 74 65 00 00 00 | 00 49 00 00 00 0e 00 00 | rate...|.I......|
|00005db0| 00 05 00 67 65 6e 72 65 | 00 00 00 00 4a 00 00 00 |...genre|....J...|
|00005dc0| 0e 00 00 00 06 00 72 61 | 74 69 6e 67 00 00 00 00 |......ra|ting....|
|00005dd0| 4b 00 00 00 0e 00 00 00 | 04 00 73 74 61 72 00 00 |K.......|..star..|
|00005de0| 00 00 4c 00 00 00 0e 00 | 00 00 0b 00 64 65 73 63 |..L.....|....desc|
|00005df0| 72 69 70 74 69 6f 6e 00 | 00 00 00 4d 00 00 00 0e |ription.|...M....|
|00005e00| 00 00 00 08 00 64 69 72 | 65 63 74 6f 72 00 00 00 |.....dir|ector...|
|00005e10| 00 4e 00 00 00 0e 00 00 | 00 04 00 6e 61 6d 65 00 |.N......|...name.|
|00005e20| 00 00 00 4f 00 00 00 0e | 00 00 00 0c 00 6d 6f 76 |...O....|.....mov|
|00005e30| 69 65 20 6e 75 6d 62 65 | 72 00 00 00 00 50 00 00 |ie numbe|r....P..|
|00005e40| 00 0f 00 00 00 0b 00 73 | 74 61 74 75 73 20 63 6f |.......s|tatus co|
|00005e50| 64 65 00 00 00 00 51 00 | 00 00 0f 00 00 00 0f 00 |de....Q.|........|
|00005e60| 63 72 65 64 69 74 20 63 | 61 72 64 20 65 78 70 00 |credit c|ard exp.|
|00005e70| 00 00 00 52 00 00 00 0f | 00 00 00 0b 00 63 72 65 |...R....|.....cre|
|00005e80| 64 69 74 20 63 61 72 64 | 00 00 00 00 53 00 00 00 |dit card|....S...|
|00005e90| 0f 00 00 00 05 00 70 68 | 6f 6e 65 00 00 00 00 54 |......ph|one....T|
|00005ea0| 00 00 00 0f 00 00 00 0c | 00 63 75 73 74 6f 6d 65 |........|.custome|
|00005eb0| 72 5f 7a 69 70 00 00 00 | 00 55 00 00 00 0f 00 00 |r_zip...|.U......|
|00005ec0| 00 0e 00 63 75 73 74 6f | 6d 65 72 5f 73 74 61 74 |...custo|mer_stat|
|00005ed0| 65 00 00 00 00 56 00 00 | 00 0f 00 00 00 0d 00 63 |e....V..|.......c|
|00005ee0| 75 73 74 6f 6d 65 72 5f | 63 69 74 79 00 00 00 00 |ustomer_|city....|
|00005ef0| 57 00 00 00 0f 00 00 00 | 12 00 63 75 73 74 6f 6d |W.......|..custom|
|00005f00| 65 72 5f 61 64 64 72 65 | 73 73 5f 32 00 00 00 00 |er_addre|ss_2....|
|00005f10| 58 00 00 00 0f 00 00 00 | 07 00 61 64 64 72 65 73 |X.......|..addres|
|00005f20| 73 00 00 00 00 59 00 00 | 00 0f 00 00 00 12 00 63 |s....Y..|.......c|
|00005f30| 75 73 74 6f 6d 65 72 5f | 6c 61 73 74 5f 6e 61 6d |ustomer_|last_nam|
|00005f40| 65 00 00 00 00 5a 00 00 | 00 0f 00 00 00 04 00 6e |e....Z..|.......n|
|00005f50| 61 6d 65 00 00 00 00 5b | 00 00 00 0f 00 00 00 0f |ame....[|........|
|00005f60| 00 63 75 73 74 6f 6d 65 | 72 20 6e 75 6d 62 65 72 |.custome|r number|
|00005f70| 00 00 00 00 5d 00 00 00 | 11 00 00 00 11 00 63 68 |....]...|......ch|
|00005f80| 65 63 6b 20 62 61 6e 6b | 20 6e 75 6d 62 65 72 00 |eck bank| number.|
|00005f90| 00 00 00 5e 00 00 00 11 | 00 00 00 0c 00 63 68 65 |...^....|.....che|
|00005fa0| 63 6b 20 6e 75 6d 62 65 | 72 00 00 00 00 60 00 00 |ck numbe|r....`..|
|00005fb0| 00 12 00 00 00 12 00 63 | 72 65 64 69 74 20 63 61 |.......c|redit ca|
|00005fc0| 72 64 20 6e 75 6d 62 65 | 72 00 00 00 00 61 00 00 |rd numbe|r....a..|
|00005fd0| 00 12 00 00 00 0f 00 63 | 72 65 64 69 74 20 63 61 |.......c|redit ca|
|00005fe0| 72 64 20 65 78 70 00 00 | 00 00 62 00 00 00 12 00 |rd exp..|..b.....|
|00005ff0| 00 00 10 00 63 72 65 64 | 69 74 20 63 61 72 64 20 |....cred|it card |
|00006000| 74 79 70 65 00 00 00 00 | 65 00 00 00 0a 00 00 00 |type....|e.......|
|00006010| 0b 00 72 65 6e 74 61 6c | 20 72 61 74 65 00 00 00 |..rental| rate...|
|00006020| 00 6d 00 00 00 05 00 00 | 00 00 00 00 00 00 00 6f |.m......|.......o|
|00006030| 00 00 00 06 00 00 00 00 | 00 00 00 00 00 70 00 00 |........|.....p..|
|00006040| 00 05 00 00 00 00 00 00 | 00 00 00 72 00 00 00 06 |........|...r....|
|00006050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 08 00 00 |........|........|
|00006060| 00 00 00 04 00 44 42 4d | 53 00 00 00 00 00 00 00 |.....DBM|S.......|
|00006070| 09 00 44 50 4f 5f 43 4c | 41 53 53 00 00 00 00 00 |..DPO_CL|ASS.....|
|00006080| 00 00 06 00 44 50 4f 5f | 49 44 00 00 00 00 00 01 |....DPO_|ID......|
|00006090| 00 08 00 44 50 4f 5f 4e | 41 4d 45 fe 00 00 00 00 |...DPO_N|AME.....|
|000060a0| 01 00 0d 00 44 50 4f 5f | 4c 41 53 54 5f 4e 41 4d |....DPO_|LAST_NAM|
|000060b0| 45 41 00 00 00 00 02 00 | 0b 00 44 50 4f 5f 45 50 |EA......|..DPO_EP|
|000060c0| 50 5f 55 44 53 00 00 00 | 00 00 00 00 0a 00 44 50 |P_UDS...|......DP|
|000060d0| 4f 5f 43 53 58 5f 49 44 | 00 00 00 00 00 02 00 08 |O_CSX_ID|........|
|000060e0| 00 44 50 4f 5f 55 44 50 | 53 00 00 00 00 00 03 00 |.DPO_UDP|S.......|
|000060f0| 00 00 08 00 00 00 ac 00 | 00 00 00 00 00 00 01 00 |........|........|
|00006100| 00 00 0a 00 6c 6f 67 73 | 65 67 6d 65 6e 74 00 00 |....logs|egment..|
|00006110| 09 00 00 00 01 00 00 00 | 0f 00 00 00 00 00 00 00 |........|........|
|00006120| 00 00 00 00 00 00 02 00 | 00 00 1e 00 00 00 00 00 |........|........|
|00006130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 09 00 00 |........|........|
|00006170| 00 01 00 00 00 0f 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006180| 00 00 00 02 00 00 00 1e | 00 00 00 00 00 00 00 00 |........|........|
|00006190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000061a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000061b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000061c0| 00 00 00 00 00 00 08 00 | 00 00 ac 00 00 00 00 00 |........|........|
|000061d0| 00 00 02 00 00 00 06 00 | 73 79 73 74 65 6d 00 00 |........|system..|
|000061e0| 09 00 00 00 01 00 00 00 | 0f 00 00 00 00 00 00 00 |........|........|
|000061f0| 00 00 00 00 00 00 02 00 | 00 00 1e 00 00 00 00 00 |........|........|
|00006200| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006210| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006220| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006230| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 09 00 00 |........|........|
|00006240| 00 01 00 00 00 0f 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006250| 00 00 00 02 00 00 00 1e | 00 00 00 00 00 00 00 00 |........|........|
|00006260| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006270| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006280| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006290| 00 00 00 00 00 00 08 00 | 00 00 ac 00 00 00 00 00 |........|........|
|000062a0| 00 00 03 00 00 00 07 00 | 64 65 66 61 75 6c 74 00 |........|default.|
|000062b0| 00 09 00 00 00 01 00 00 | 00 0f 00 00 00 00 00 00 |........|........|
|000062c0| 00 00 00 00 00 00 00 02 | 00 00 00 1e 00 00 00 00 |........|........|
|000062d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006300| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 09 00 |........|........|
|00006310| 00 00 01 00 00 00 0f 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006320| 00 00 00 00 02 00 00 00 | 1e 00 00 00 00 00 00 00 |........|........|
|00006330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006360| 00 00 00 00 00 00 00 0e | 00 00 00 0f 00 05 00 00 |........|........|
|00006370| 00 d2 01 00 00 85 02 00 | 00 56 02 00 00 ad 02 00 |........|.V......|
|00006380| 00 1f 02 20 0a e6 01 97 | 1a 11 00 4f 56 45 52 44 |... ....|...OVERD|
|00006390| 55 45 5f 4e 4f 54 49 43 | 45 00 00 00 00 00 03 00 |UE_NOTIC|E.......|
|000063a0| 01 00 00 00 00 00 00 00 | 00 00 01 00 00 00 00 00 |........|........|
|000063b0| 00 00 00 00 0e 00 4f 56 | 45 52 44 55 45 5f 4e 4f |......OV|ERDUE_NO|
|000063c0| 54 49 43 45 00 00 00 00 | 0d 00 00 00 01 00 00 00 |TICE....|........|
|000063d0| 28 00 00 00 00 02 00 00 | 00 28 00 00 00 00 02 00 |(.......|.(......|
|000063e0| 00 00 00 00 00 00 00 02 | 00 00 00 00 00 00 00 00 |........|........|
|000063f0| 01 00 00 00 64 00 00 00 | 00 00 00 00 00 00 00 00 |....d...|........|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
